mykal66
05-10-2017, 01:12 AM
Hi
I have found several pieces of code on the internet but cannot adapt any of them to do what I need so looking for help if anyone can please?
I have a report at work which I have to update daily with new data but I need to be able to drop the updated report into a new tab then use macro to check if the data already exists in original tab, if delete the entire line so only new data remains. Then I need it to copy the new data to the bottom of the existing data tab.
In the attached example, DATA is the constant report and ADDITIONAL where I would drop new data. There are several lines of header infor, summaries etc so it would check Columns D in both tabs from row 12 and look for duplicates, so anything identified in Additional as already existing in DATA would have the entire row deleted to leave only new rows to pull over to the data tab – just the 3 rows highlighted in green in example.
These rows would then be automatically added to the bottom of the DATA tab giving one dataset without any duplicates.
As always, your help is always appreciated
Mykal
19117
I have found several pieces of code on the internet but cannot adapt any of them to do what I need so looking for help if anyone can please?
I have a report at work which I have to update daily with new data but I need to be able to drop the updated report into a new tab then use macro to check if the data already exists in original tab, if delete the entire line so only new data remains. Then I need it to copy the new data to the bottom of the existing data tab.
In the attached example, DATA is the constant report and ADDITIONAL where I would drop new data. There are several lines of header infor, summaries etc so it would check Columns D in both tabs from row 12 and look for duplicates, so anything identified in Additional as already existing in DATA would have the entire row deleted to leave only new rows to pull over to the data tab – just the 3 rows highlighted in green in example.
These rows would then be automatically added to the bottom of the DATA tab giving one dataset without any duplicates.
As always, your help is always appreciated
Mykal
19117