asked on How to merge varying numbers of rows from two worksheets to appear on a single worksheet with a blank row to separate the data?
After running a macro to query a database that changes daily, I get two worksheets with formatted reports that may randomly vary between 10 and 15 rows each day.
I would like to copy the rows from Sheet1, and paste it below the last row of data on Sheet2, leaving a blank row between the two reports. I would add this code at the end of the macro to generate the merged report.
Example-of-Merged-Reports.xlsx
I would like to copy the rows from Sheet1, and paste it below the last row of data on Sheet2, leaving a blank row between the two reports. I would add this code at the end of the macro to generate the merged report.
Example-of-Merged-Reports.xlsx
VBAMicrosoft ExcelMicrosoft Office
Last Comment
Steve Lowry
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
This is a one line of code. On my screen it is showing as two lines.
Maybe better to have
With Sheet1
.Range(.Range("A1"), .Range("A" & Rows.Count).End(xlUp)).Copy Sheet2.Range("A" & Rows.Count).End(xlUp).Offset(2)
End With
ASKER
This works great. Thanks for your help today.
Steve
Steve