Hi,
I have a spreadsheet where I'd like to be able to find the last 3 active columns, copy them and paste them into the next blank column for the active sheet.
So e.g., column Z is my last column with data, so I need to copy X, Y and Z, then paste them into AA, AB and AC.
It will always be the same sheet (Sheet 1) which I'm copying and pasting from and into, so the sheet name can be specified (i.e. it doesn't have to be for whichever sheet is active at the time.
Any help would be greatly appreciated.
Cheers,
Ross
Bookmarks