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