We periodically enter data to a Consolidated Worksheet that derives from date two other worksheets. The two other worksheets are being enter data on a daily basis. Once a month another user get these 2 worksheets and copy/paste its content to the Consolidated Worksheet.
We are trying to use VBA in order to import the data from the other 2 worksheet.
We have included the 3 excel in question with sample data:
- ConsolidateExcel-Origin1.xlsx - one of two other worksheets
- ConsolidateExcel-Origin2.xlsx - one of two other worksheets
- ConsolidateExcel-Final.xlsx - the Consolidated Worksheet
Please advice n how to go about it.