hi
Excel 2007
I am entering information into an excel sheet one day/column at a time. So 2/08/08 is sitting in column c 1/08/07 is sitting in column d and so on rolling back along the sheet. This allows me masses of day that I can store.
What I wish to do is to take the information that is sitting per day in “sheet 1” put it into “sheet 2” in weekly a weekly layout, with the information average or added together.
Then take the information in the weekly, do the same paste it in “sheet 3” per calendar month, “sheet 4” per 3 months “ sheet 5” per 6 months and “sheet 6” per year.
This would have to all update daily as new information is entered. And I would like the Macro to be as efficient as possible doing so.
I have struggled to do this, and have been doing it manually typing in the formulas going back 7 and so on days at a time. And it is really slow when the macro copies what I have done.
Can any one show me a more efficient easier way of doing this?
Bookmarks