I have a worksheet with 2 columns.
Column 1 is Latest update.
Column 2 is Archive update.
I want to write a macro that would detect the cell I've selected, copy its contents, and paste it into the top of the archived update cell.
BEFORE:
CELL A1 CELL B1
Update 5 Update 4
Update 3
Update 2
Update 1
After I select cell A1 and run the Macro
AFTER:
CELL A1 CELL B1
Update 5
Update 4
Update 3
Update 2
Update 1
I'm imagining a macro tht copy cells, offset (0,1), then paste content but I'm havin trouble retining existing data in the Column B cells
Column 1 is Latest update.
Column 2 is Archive update.
I want to write a macro that would detect the cell I've selected, copy its contents, and paste it into the top of the archived update cell.
BEFORE:
CELL A1 CELL B1
Update 5 Update 4
Update 3
Update 2
Update 1
After I select cell A1 and run the Macro
AFTER:
CELL A1 CELL B1
Update 5
Update 4
Update 3
Update 2
Update 1
I'm imagining a macro tht copy cells, offset (0,1), then paste content but I'm havin trouble retining existing data in the Column B cells