sooty8
01-31-2011, 08:24 AM
Hi All
I have a weekly sheet within the workbook and every Tuesday I receive it. Column A is always in the same alphabetical order as in the attached file and it covers rows 2 thru 23 ( although only 3 are displayed with data changed for obvious reasons) I have to do a yearly account say we start with Chunal -SC as displayed and it is entered on the 2nd row of the Yearly Sheet on the (2) Weekly sheet Chunal - SC is automatically updated with the new totals added to the one already in place and so on down the rows 2 thru 23 - I need to retain all the sheets within the workbook for year end checking. Would prefer it within a Macro that on click would do the update.
Regards
Sooty 8
I have a weekly sheet within the workbook and every Tuesday I receive it. Column A is always in the same alphabetical order as in the attached file and it covers rows 2 thru 23 ( although only 3 are displayed with data changed for obvious reasons) I have to do a yearly account say we start with Chunal -SC as displayed and it is entered on the 2nd row of the Yearly Sheet on the (2) Weekly sheet Chunal - SC is automatically updated with the new totals added to the one already in place and so on down the rows 2 thru 23 - I need to retain all the sheets within the workbook for year end checking. Would prefer it within a Macro that on click would do the update.
Regards
Sooty 8