Hi can anyone help with a macro to copy a range of data from one workbook to another?
I have rows of data on workbook1 sheet(Data) range A2:H that I want to copy to workbook2 sheet(Data).
I need the data to copy to workbook2 in the same columns as workbook1 but continue the data to the next rows from where the last data was copied.
Column A has number count for each set of data with empty cells between each set of data, this is where I am struggling to find the last empty row to continue the data.
ie workbook2 has the following data A2:H29
<tbody>
</tbody>I want to use a macro to copy the next set of data from workbook1 to continue the data on workbook2
ie workbook1 has the following data A2:H36
<tbody>
</tbody>
So the copied range would continue on workbook2 from A30:H
Any help would be aprieciated
Regards
pwill
I have rows of data on workbook1 sheet(Data) range A2:H that I want to copy to workbook2 sheet(Data).
I need the data to copy to workbook2 in the same columns as workbook1 but continue the data to the next rows from where the last data was copied.
Column A has number count for each set of data with empty cells between each set of data, this is where I am struggling to find the last empty row to continue the data.
ie workbook2 has the following data A2:H29
1 | A | B | C | D | E | F | G |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
2 | A | B | C | D | E | F | G |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
3 | A | B | C | D | E | F | G |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
4 | A | B | C | D | E | F | G |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
<tbody>
</tbody>
ie workbook1 has the following data A2:H36
5 | A | B | C | D | E | F | G |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
6 | A | B | C | D | E | F | G |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
7 | A | B | C | D | E | F | G |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
8 | A | B | C | D | E | F | G |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
9 | A | B | C | D | E | F | G |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G | |
A | B | C | D | E | F | G |
<tbody>
</tbody>
So the copied range would continue on workbook2 from A30:H
Any help would be aprieciated
Regards
pwill
Last edited: