Hello all - hoping you may be able to help me again here although I think this may be a bit of a tricky one..
Basically each week I get a report on e-mail and what I have to do is add all new data to an existing report but avoid duplicates etc. What I need is a formula that looks through the existing report and picks out from the new report anything thats missing then starts a new row and inserts all the relevant fields (if any of that makes sense) The only field that is individual to each record is the ARN number.
I have attached a mock example of what I mean to help to explain this.
Tab "Main data" is the existing report and I would need to formula to start in A6 and copy accross and down
Tab "New Data" is where I will paste the data I get from the weekly report.
So any field that shows in the "new data tab" and is not already in the "Main data" tab needs to be automatically picked out and automatically added as a new row to "Main data".
While the formula is dorment - I am hoping it will not show N/A but maybe a 0 or blank cell
If this makes any sense at all I would appreciate any help
Thanks Very Much !!
HELP.zip
Bookmarks