Teach Yourself Excel Lesson Inserting And Renaming Worksheets

Help please. A MatLab 7.2 program must read 1000 files created in Excel
2000. The current system has Excel 2003 and has different rules for sheet
names. It will not allow MatLab 7.2 to read what it considers flawed files.
The Excel files are in a directory with other files. How can I change the
names of two sheets on each of 1000 files without it being a one-at-the-time
process?
--
James L. Smith

Does anyone know where i can find lesson plans for powerpoint and excel? i'm starting private lessons with my first customer this weekend so really need something asap!

thanks!

x

In Lesson 4 in "Grouping Fields" part, in the following paragraph:

" At present, our Names heading is the inner most row field. Lets change that now by left clicking on our Date of Birth field (column heading in C4) and dragging it to the left and dropping it in A4 so that it becomes the inner most row field (left). Now select Group Selection under Group optionson the Options tab, scroll down and highlight the word Year ensuring the you unhighlight Months. "

When we want to change "Date of birth" field, you mention that it is in column heading in C4, but the cell C4 is empty there is no data. The same thing happens for Age field.
Therefore, we can't group by those fields, because we can't do them the inner most row fields.

Hi all,

I'm relatively new to VBA and require programming help with the following:

I have created a button to add a specific worksheet template ("TE - Template") after another worksheet ("CO - Cockpit") and then name it:

Sub Add_worksheet()
Sheets("TE - Template").Select
Sheets("TE - Template").Copy After:=Sheets("CO - Cockpit")
ActiveSheet.Name = "AL - Class 1"
End Sub

However, I would like to let Excel check (via VBA) if the "AL - Class 1" worksheet already exists. If it does, the same template sheet should be added but named differently: "AL - Class 2". This should be possible for X worksheets (i.e., "AL - Class (X + 1)" everytime I add a new template worksheet. Thus, I would like to keep the same name (i.e., "AL - Class"), but with an increasing number (i.e., 1, 2, 3, X).

Can anyone tell me how I should amend the above code or supply me with a better (and efficient) way of programming this query?

Thankx!

Chester

Hi all,

I'm relatively new to VBA and require programming help with the following:

I have created a button to add a specific worksheet template ("TE - Template") after another worksheet ("CO - Cockpit") and then name it:

Sub Add_worksheet()
Sheets("TE - Template").Select
Sheets("TE - Template").Copy After:=Sheets("CO - Cockpit")
ActiveSheet.Name = "AL - Class 1"
End Sub

However, I would like to let Excel check (via VBA) if the "AL - Class 1" worksheet already exists. If it does, the same template sheet should be added but named differently: "AL - Class 2". This should be possible for X worksheets (i.e., "AL - Class (X + 1)" everytime I add a new template worksheet. Thus, I would like to keep the same name (i.e., "AL - Class"), but with an increasing number (i.e., 1, 2, 3, X).

Can anyone tell me how I should amend the above code or supply me with a better (and efficient) way of programming this query?

Thankx!

Chester

hi,
can anyone teach me advanced excel/macro with VB concepts.Some real time experience I am looking in this field.Of course somebody could assist with a job @ the end of the course nothing like that.

I need to hire an Excel / Dreamweaver Guru to teach me...
I am looking for someone who fits these 4 basic needs I have:

1. must have code & excel skills
2. must be a dreamweaver expert
3. must be online with chat most of the time
4. must have an affordable hourly rate
5. must be okay with screen sharing and viewing my desktop to teach me

I am learning SEO and designing web sites with excel and Dreamweaver WYSIWYG for 7 years, but still haven't learned the nuts and bolts of code. Ideally I am looking for a person that can be available for short 30 minute-1 hour increments...and bill me ongoing in an excel spreadsheet, I am willing to pay you a set paycheck every couple weeks. Please let me know what your experience is with SEO and Web Design, examples of your work are helpful. The work will be random hours. I can work around your schedule as much as possible. I am online from 10AM PST to 10PM PST so any of those times would work fine with me. Ideally from 7-10PM PST. Thanks! my contact is email address removed by Moderator P.S. I am also looking for a good low cost link builder that knows how to make helpful comments on relevant blogs.

Format for response - please answer all in your initial approach to me:
1. do you have code & excel skills?
2. are you a dreamweaver expert?
3. what time are you available on chat? (include time zone)
4. what is your hourly rate?
5. what is your company website?
6. are you okay with screen sharing and viewing my desktop to teach me?
7. do you accept paypal?
8. when can you start?

Thanks,

Edit: Email address removed by Moderator

My boss has asked me to teach to a group of employees some basics of excel. At the office, I'm the excel expert, but I'm way behind many of the MVP's here.

The group is a sales organization. They routinely use Excel to view information, but rarely create sheets for others, but many have expressed interest to learn how to do so.

I was thinking excel navigating basics like adding columns, rows, worksheets, etc. Page Setup, Formatting Cells, Reference formulas, Charting, & maybe Pivot tables.

I'm looking for a book that gives a good organized guide with practice examples. Any help would be appreciated. Thanks!

Hi,

Just a quick on i hope. Im trying to create a macro that adds a worksheet/tab and Rename it to the month after the tab already showing.

e.g

if i already have two tabs one dated january and the other named february i require the macro to say march then the next run would be april if you get my drift.

if anyone could help it would be greatly appreciated

thank you

Hello,

I am trying to teach Excel to understand a tv programming schedule.
I have a database of a few hundred programs from which simple tables (through linked cells) on different worksheets "fish" out selected data into pretty presentations.

IE: in cell B2 ='datasheet1'$A$1 and so on vertically to display only what I want to show in the table such as program name, channel, genre etc.

Two of the cells will ideally contain the "lead-in" (scheduled right before) and "lead-out" (scheduled right after) programming on the same channel, as well as programming competing with the same time slot.

In my database I have the start and end times (with duration column) and the day and here is my questions:

1- Is this possible?
2- How can I tell Excel to produce the lead-in, lead-out, and simultaneous programming in my linked tables?

Thank you!