I have simple sheet of data and dates. There is a bit of a challenge in the format. We do not display Saturday and Sundays and have a weekly average stuck at the end of a blank row.
Example
M 2/5/07 Data
T 2/6/07 Data
W 2/7/07 Data
Th 2/8/07 Data
F 2/9/07 Data
T 2/11/07 Data
I want to delete the cells that are older than one week starting on a Monday and add the same number of weeks at the end of the sheet. I want to add the same number of weeks as deleted by copying the data in the end of the spreadsheet (24 months in the future) and changing the dates.
I go to VBA class about every 2 years and then rarely use it. Any help will be greatly appreciated!
Example
M 2/5/07 Data
T 2/6/07 Data
W 2/7/07 Data
Th 2/8/07 Data
F 2/9/07 Data
Week avg Data
M 2/10/07 Data
T 2/11/07 Data
I want to delete the cells that are older than one week starting on a Monday and add the same number of weeks at the end of the sheet. I want to add the same number of weeks as deleted by copying the data in the end of the spreadsheet (24 months in the future) and changing the dates.
I go to VBA class about every 2 years and then rarely use it. Any help will be greatly appreciated!