Hi,
I am after a code that will copy data from last row to next row and then clear data from the copied row between Col A-K.
So in the below test data, copy row 2 to row 3 then clear data from A3 to K3.
Please note Col A will have data validation list, so the code will need to paste validation aswell
I am after a code that will copy data from last row to next row and then clear data from the copied row between Col A-K.
So in the below test data, copy row 2 to row 3 then clear data from A3 to K3.
Please note Col A will have data validation list, so the code will need to paste validation aswell
Excel Workbook | |||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | |||
1 | Header1 | Header2 | Header3 | Header4 | Header5 | Header6 | Header7 | Header8 | Header9 | Header10 | Header11 | Header12 | Header13 | ||
2 | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | Test7 | Test8 | Test9 | 0 | 2 | 2 | Test13 | ||
Sheet1 |