Hi All,
I want to record a macro wherein each new week you just drag everything in one column over to the next column (literally just copy column AM and paste on AN, for example). The reason for the macro is that I have to do this on roughly 75 tabs, so it takes some time.
However, I'd like for it to be able to update weekly, so that each week it's always copying and pasting the last column with data into the first blank column. So next week, column AN would be copied to AO, and on and on.
Is there some way to perhaps have the macro find the first blank cell in Row 1 or whatever, and then paste the column to the left of that into that blank column, and then each time you run the macro, it just adds a new column to your spreadsheet?
Hopefully my explanation has been clear. Thank you so much for your time.
Best,
Ernie
I want to record a macro wherein each new week you just drag everything in one column over to the next column (literally just copy column AM and paste on AN, for example). The reason for the macro is that I have to do this on roughly 75 tabs, so it takes some time.
However, I'd like for it to be able to update weekly, so that each week it's always copying and pasting the last column with data into the first blank column. So next week, column AN would be copied to AO, and on and on.
Is there some way to perhaps have the macro find the first blank cell in Row 1 or whatever, and then paste the column to the left of that into that blank column, and then each time you run the macro, it just adds a new column to your spreadsheet?
Hopefully my explanation has been clear. Thank you so much for your time.
Best,
Ernie