Hello everyone,
I'm trying to create a macro that copies cells from A1:C3 in one workbook and pastes them in the last row with the text Period Three in another workbook in column C. Every time a new last row has period 3 that data will only paste in that new last row with Period Three.
This is workbook 1 sheet 1
This is workbook 2 sheet 1
Thanks for any help.
I'm trying to create a macro that copies cells from A1:C3 in one workbook and pastes them in the last row with the text Period Three in another workbook in column C. Every time a new last row has period 3 that data will only paste in that new last row with Period Three.
This is workbook 1 sheet 1
1 | 2 | 3 |
4 | 5 | 6 |
7 | 8 | 9 |
date | key | Period One | |||||||||
date | key | Period Two | |||||||||
date | key | Period Three | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
Thanks for any help.