I've just started this job, and I know this can be done easier than it is right now. Currently, it takes days to manually locate changed data in a newly submitted file (WB2) and update the master spreadsheet (WB1).
I've used the Compare worksheet function in Excel 2016 which has provided me some information (at least I can use that to see what lines have changed); however, having to review and update to a new spreadsheet with 1000+ lines with values is painful (I have many).
This project has WB1 is master file, and WB2 is "slave" with updated info. The workbooks are identical EXCEPT for the updates in WB2, which may include new rows.
Is there a way to:
1. Compare sheet 1 of of WB1 against sheet 1 of WB2 then
2. Take that output and create the new WB3?
Can I take what is NOT changed in WB1 -- as well as what HAS changed (in WB2) -- and create or merge results to a WB3 (with changes highlighted)?
I cannot see this functionality anywhere, and I'm an early learner with VBA. I'd appreciate ANY advice/direction.
I've used the Compare worksheet function in Excel 2016 which has provided me some information (at least I can use that to see what lines have changed); however, having to review and update to a new spreadsheet with 1000+ lines with values is painful (I have many).
This project has WB1 is master file, and WB2 is "slave" with updated info. The workbooks are identical EXCEPT for the updates in WB2, which may include new rows.
Is there a way to:
1. Compare sheet 1 of of WB1 against sheet 1 of WB2 then
2. Take that output and create the new WB3?
Can I take what is NOT changed in WB1 -- as well as what HAS changed (in WB2) -- and create or merge results to a WB3 (with changes highlighted)?
I cannot see this functionality anywhere, and I'm an early learner with VBA. I'd appreciate ANY advice/direction.