Copying Data to Another Workbook

P

pwill

Active Member
Joined
Nov 22, 2015
Messages
406
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>
[TD="class: xl63"] 1
 [/TD]
[TD="class: xl63, width: 64"] A [/TD]
[TD="class: xl63, width: 64"] B [/TD]
[TD="class: xl63, width: 64"] C [/TD]
[TD="class: xl63, width: 64"] D [/TD]
[TD="class: xl63, width: 64"] E [/TD]
[TD="class: xl63, width: 64"] F [/TD]
[TD="class: xl63, width: 64"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"] 2 [/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"] 3 [/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"] 4 [/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"]
[/TD]
[TD="class: xl63"] A [/TD]
[TD="class: xl63"] B [/TD]
[TD="class: xl63"] C [/TD]
[TD="class: xl63"] D [/TD]
[TD="class: xl63"] E [/TD]
[TD="class: xl63"] F [/TD]
[TD="class: xl63"] G [/TD]

[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]
[TD="class: xl63"][/TD]

</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>
[TD="class: xl65"] 5
 [/TD]
[TD="class: xl65, width: 64"] A [/TD]
[TD="class: xl65, width: 64"] B [/TD]
[TD="class: xl65, width: 64"] C [/TD]
[TD="class: xl65, width: 64"] D [/TD]
[TD="class: xl65, width: 64"] E [/TD]
[TD="class: xl65, width: 64"] F [/TD]
[TD="class: xl65, width: 64"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"] 6
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"] 7
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"] 8
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"]
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"] 9
[/TD]
[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

[TD="class: xl65"] A [/TD]
[TD="class: xl65"] B [/TD]
[TD="class: xl65"] C [/TD]
[TD="class: xl65"] D [/TD]
[TD="class: xl65"] E [/TD]
[TD="class: xl65"] F [/TD]
[TD="class: xl65"] G [/TD]

</tbody>


So the copied range would continue on workbook2 from A30:H

Any help would be aprieciated

Regards

pwill
 
Last edited:

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple
Sort by date Sort by votes
Assuming both workbooks are open, place the following macro in a regular module in Book1 and save the workbook as a macro-enabled file. Change the workbook names in the code to match your actual names including the file extension. Also change the sheet names to suit your needs if necessary.
Code: 
Sub CopyData()
    Application.ScreenUpdating = False
    Dim bottomB1 As Long
    bottomB1 = Workbooks("Book1.xlsm").Sheets("Sheet1").Range("B" & Rows.Count).End(xlUp).Row
    Dim bottomB2 As Long
    bottomB2 = Workbooks("Book2.xlsx").Sheets("Sheet1").Range("B" & Rows.Count).End(xlUp).Row
    Workbooks("Book1.xlsm").Sheets("Sheet1").Range("A1:H" & bottomB1).Copy Workbooks("Book2.xlsx").Sheets("Sheet1").Cells(bottomB2 + 1, 1)
    Application.ScreenUpdating = True
End Sub
 
Upvote 0
mumps said:
Assuming both workbooks are open, place the following macro in a regular module in Book1 and save the workbook as a macro-enabled file. Change the workbook names in the code to match your actual names including the file extension. Also change the sheet names to suit your needs if necessary.
Code: 
Sub CopyData()
    Application.ScreenUpdating = False
    Dim bottomB1 As Long
    bottomB1 = Workbooks("Book1.xlsm").Sheets("Sheet1").Range("B" & Rows.Count).End(xlUp).Row
    Dim bottomB2 As Long
    bottomB2 = Workbooks("Book2.xlsx").Sheets("Sheet1").Range("B" & Rows.Count).End(xlUp).Row
    Workbooks("Book1.xlsm").Sheets("Sheet1").Range("A1:H" & bottomB1).Copy Workbooks("Book2.xlsx").Sheets("Sheet1").Cells(bottomB2 + 1, 1)
    Application.ScreenUpdating = True
End Sub
Click to expand...



Thanks mumps

After changing sheet names etc.. your code works perfect

regards
pwill
 
Upvote 0
You must log in or register to reply here.

Similar threads

ExcelNewbie2020
  • Solved
extract the header of sets of non empty cell
Replies
3
Views
95
ExcelNewbie2020
ExcelNewbie2020
G
  • Question Question
Rearrange data into two columns
Replies
3
Views
66
Fluff
Fluff
A
  • Solved
Return Records if a match is found
Replies
4
Views
167
agentkramr
A
M
  • Solved
Absolute Reference - Change absolute range without manual intervention
Replies
7
Views
496
Peter_SSs
Peter_SSs
serge
  • Question Question
#N/A cell skip.
Replies
3
Views
268
Peter_SSs
Peter_SSs

Forum statistics

Threads
1,223,907
Messages
6,175,301
Members
452,633
Latest member
DougMo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top