Merge WB2 data into WB1 then delete WB2.
The process creates 2 excel files via CSV, so they are exactly the same format, same exact header.
Each workbook has 1 tab.
The two Excel Workbooks are in one folder WB1, WB2 - always named the exact same.
Need to open WB2, copy all but the header,
open WB1, go to end of rows,
paste WB2 records,
Save WB1, close it
close wb2 and Delete it.
The process creates 2 excel files via CSV, so they are exactly the same format, same exact header.
Each workbook has 1 tab.
The two Excel Workbooks are in one folder WB1, WB2 - always named the exact same.
Need to open WB2, copy all but the header,
open WB1, go to end of rows,
paste WB2 records,
Save WB1, close it
close wb2 and Delete it.