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

A
  • Solved
Return Records if a match is found
Replies
4
Views
162
agentkramr
A
M
  • Solved
Absolute Reference - Change absolute range without manual intervention
Replies
7
Views
434
Peter_SSs
Peter_SSs
serge
  • Question Question
#N/A cell skip.
Replies
3
Views
247
Peter_SSs
Peter_SSs
J
  • Question Question
Automatically move cells from one sheet to another based on criteria using VBA
Replies
5
Views
707
DanteAmor
DanteAmor
N
  • Solved
Sumproduct with Table Rows doesn't work
Replies
8
Views
217
Nicha
N

Forum statistics

Threads
1,223,227
Messages
6,170,849
Members
452,361
Latest member
d3ad3y3

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