A
Ann
I have two workbooks one called monthly and the other called EOM.
The monthly workbook has 14 sheets (i.e. one for each month {e.g. Jan
Feb..}). One that has data is used in the 12 monthly sheets as a pick list.
The last sheet (sheet name charge) has month names that need to be invoiced
for (e.g. FEB MAR APRIL (in cells A1 A2 and A3).
Is there a way that a macro can be written that will do the following: -
First month specified, copy the whole spreadsheet;
Second and third months specified, copy from row 3 to the end.
Data should be copied to workbook EOM, sheet EOM. If sheet EOM exists, it
should be replaced. All the data that needs to be copied should be copied as
values (as there are formulas in the sheets) and if at all possible the
formatting in terms of column heights, widths and other cell characteristics
should be retained.
The copying to the EOM should only occur when the sheet charge is populated
with data in cells a1 through a3.
Finally I want sheet EOM sorted by column A, G and H.
Any help would be greatly appreciated.
The monthly workbook has 14 sheets (i.e. one for each month {e.g. Jan
Feb..}). One that has data is used in the 12 monthly sheets as a pick list.
The last sheet (sheet name charge) has month names that need to be invoiced
for (e.g. FEB MAR APRIL (in cells A1 A2 and A3).
Is there a way that a macro can be written that will do the following: -
First month specified, copy the whole spreadsheet;
Second and third months specified, copy from row 3 to the end.
Data should be copied to workbook EOM, sheet EOM. If sheet EOM exists, it
should be replaced. All the data that needs to be copied should be copied as
values (as there are formulas in the sheets) and if at all possible the
formatting in terms of column heights, widths and other cell characteristics
should be retained.
The copying to the EOM should only occur when the sheet charge is populated
with data in cells a1 through a3.
Finally I want sheet EOM sorted by column A, G and H.
Any help would be greatly appreciated.