Faintkitara
Board Regular
- Joined
- Jun 23, 2016
- Messages
- 59
Hello,
I'm trying to figure out how to make a macro that copies all columns named " Current Projection" in row 4 and pastes them right after each other. So wherever a column says "Current Projection" in row 4 i pretty much want that column to be duplicated. I tried doing this myself but of course macrorecorder can only go so far. For example row 4 would look like this (with corresponding data below it):
<tbody>
</tbody>
I want it to look like this:
<tbody>
</tbody>
On top of that I also wanted to get code on how to rename every first "Current Projection" column of the duplicates, a date that is seven days more than the date listed the column before it.
So from this:
<tbody>
</tbody>
To this:
<tbody>
</tbody>
Any response would be greatly appreciated! Thank you!!!
I'm trying to figure out how to make a macro that copies all columns named " Current Projection" in row 4 and pastes them right after each other. So wherever a column says "Current Projection" in row 4 i pretty much want that column to be duplicated. I tried doing this myself but of course macrorecorder can only go so far. For example row 4 would look like this (with corresponding data below it):
5/5 | 5/12 | Current Projection | Accounts | Current Projection | Totals |
<tbody>
</tbody>
I want it to look like this:
5/5 | 5/12 | Current Projection | Current Projection | Accounts | Current Projection | Current Projection | Totals |
<tbody>
</tbody>
On top of that I also wanted to get code on how to rename every first "Current Projection" column of the duplicates, a date that is seven days more than the date listed the column before it.
So from this:
5/5 | 5/12 | Current Projection | Current Projection | Accounts | 7/2 | 7/9 | Current Projection | Current Projection | Totals |
<tbody>
</tbody>
To this:
5/5 | 5/12 | 5/19 | Current Projection | Current Projection | Accounts | 7/2 | 7/9 | 7/16 | Current Projection |
<tbody>
</tbody>
Any response would be greatly appreciated! Thank you!!!