That is the best way to learn. If you want some help take a look at the
Excel.Programming section (You are in Excel.Worksheet.Functions at the
moment). There are lots of good examples and piles of very accomplished Excel
programmers.
--
HTH...

Jim Thomlinson


"Nicole Seibert" wrote:

Thanks to both of you. I think I am going to try and do this before I ask for
any more help.

"Jim Thomlinson" wrote:

Sorry. Work got nuts and I could not get back to your question. Do you still
need help with this?
--
HTH...

Jim Thomlinson


"Nicole Seibert" wrote:

Oh, and can I tell Excel to create a column and put the information there
...after the last column with information in it.
Thanks again.

"Jim Thomlinson" wrote:

What you want to do requires VBA. You can not just record what you want. It
will look something like this...

sub DoSomeStuff()
dim wks as worksheet

for each wks in worksheets
wks.cells(rows.count, "A").end(xlup).offset(1, 0).formula = "=1+2"
next wks
exit sub

This puts the formula =1+2 into the first empty cell in column A of every
sheet. What I need to know is what formula do you need and are there any
sheets that should be excluded.
--
HTH...

Jim Thomlinson


"Nicole Seibert" wrote:

How can I create a macro that works on a number of sheets all at once in
which the lists are mulitple lengths. In other words, one sheet has 134
entries while the second has 524 and so on. I need to create a column in
which a formula recognizes type of worker and then spits out the hours per
week. The formula is done.
How can I get Excel to recognize the differing column lengths and fill in
the formula accordingly? I have tried going to the bottom of the data and
shift-arrowup, but this doesn't work.
Please keep in mind that I don't speak VBA, but record my macros.
Thanks,
Nicole