jerryr0125
05-29-2017, 05:22 PM
Hi - I am looking for assistance with a macro.
Say I have the following :
Workbook01.xlm - sheet 1 with 10,500 rows (the number of rows can vary)
Workbook02.xlm - sheet 2 with 9,500 rows (the number of rows can vary)
Both Workbooks/sheets have the same columns.
I would like to have the following :
Workbook03.xlm has a macro when executed takes the 10,500 rows from Workbook01.xlm sheet 1
and Workbook02.xlm sheet 2 and copies them into Workbook 03.xlm sheet 3 - all the rows.
The end result would be Workbook 03.xlm sheet 3 would have all rows (20,000 total).
Again, the number of rows coming from sheet 1 and sheet can vary.
thoughts ??? jerry
Say I have the following :
Workbook01.xlm - sheet 1 with 10,500 rows (the number of rows can vary)
Workbook02.xlm - sheet 2 with 9,500 rows (the number of rows can vary)
Both Workbooks/sheets have the same columns.
I would like to have the following :
Workbook03.xlm has a macro when executed takes the 10,500 rows from Workbook01.xlm sheet 1
and Workbook02.xlm sheet 2 and copies them into Workbook 03.xlm sheet 3 - all the rows.
The end result would be Workbook 03.xlm sheet 3 would have all rows (20,000 total).
Again, the number of rows coming from sheet 1 and sheet can vary.
thoughts ??? jerry