2001sleeper
New Member
- Joined
- Aug 16, 2017
- Messages
- 3
Hello,
As many other posts I am a beginner and not sure where to start.
I have a spreadsheet for process pH values that is setup as follows:
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
Row 1 is where the dates are found and I am wanting to have a macro that will only keep TODAY()-7 days. So basically, every day I open the spreadsheet OR manually run the macro, all columns older than 7 days will be cut and relocated to an Archive spreadsheet and the empty columns will be deleted allowing the data to shift left.
Is this possible?
As many other posts I am a beginner and not sure where to start.
I have a spreadsheet for process pH values that is setup as follows:
Date | 8/1/2017 | 8/2/2017 | 8/3/2017 | 8/4/2017 |
PH | PH | PH | PH | PH |
Sump1 | 7.85 | 7.52 | 7.46 | 7.38 |
Sump2 | 7.54 | 7.48 | 7.20 | 7.40 |
Sump3 | 8.03 | 8.42 | 7.53 | 7.50 |
<colgroup><col><col span="4"></colgroup><tbody>
</tbody>
Row 1 is where the dates are found and I am wanting to have a macro that will only keep TODAY()-7 days. So basically, every day I open the spreadsheet OR manually run the macro, all columns older than 7 days will be cut and relocated to an Archive spreadsheet and the empty columns will be deleted allowing the data to shift left.
Is this possible?