Slightly more complicated than simply merging two spreadsheets

[4thgenlude]

k, so I've got a spreadsheet that I download off a website with the status of a bunch of projects. I usually download the spreadsheet, and go through the list of projects and add my notes, or more information about the job status. But then the spreadsheet on the website gets updated with new jobs, and with new information on the old ones.

So I'm looking for a way to merge the spreadsheet that I already went through and added my notes and formatting to, with the updated information when I download a new spreadsheet.

I hope I'm making sense. I attached one example of the file that I formatted and added some info too (a rough one) and I attached the updated spreadsheet that ill download periodically.

Any ideas on how I can just update some columns with info from the new spreadsheet, and still keep the info I've added? But also add new rows for all the new jobs that I havent looked at yet?

Thanks in advance, and please let me know if I can clarify at all.

[Tinbendr]

This assumes that column B is unique.

In a standard module.

Please Login or Register  to view this content.