macro ?
Tab one is 2006, tab two is 2007.. Tab 3 is difference.
Tab 1 (2006) will have text then $$ in columns C to O (12 columns and
total ), Tab 2 will have text then $$ in columns C to O ( 12 columns and
total).
Tab 3 will have Tab 1 less Tab 2 in columns C to O.
Pretty much a standard worksheet BUT there will be abut 200 worksheets and
it seems to me to be easier with a macro that will fill in the rows
depending on what is in column C on tab 1 or 2.
The worksheets will be different length, but the last line will read
"Total non-salary" ..
Any help would be appreciated as to getting this done without 5 minutes a
worksheet or about 16 hours..
|