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