A macro that would...
Posted by IML on May 24, 2001 11:21 AM
I know zero about VBA, so feel free to pass if this is too big a task.
Here is what I have:
I have a large spreadsheet (49C * 39K R)
Here is what I would like:
I'd like to key on Column A which is employee number for about 60 employees. Incidentally, it is already sorted by employee number
I'd like each employee to be put on his/her own worksheet or workbook and have it sorted by 3 columns (E, then G, then AG).
I'd like to include the header row (row1) on each of the individual worksheets.
Pipe dream or possible?
Thanks in advance,