Need to Keep Comments Constant when File Updates

[BYizz]

Hello, I must download a new Excel file daily. However, the file contains a list of project numbers that I comment on with respect to the progress of each project. I'm trying to figure out a way to download the new file yet keep the comments section constant with respect to each project. For example:

Column A: Column B:
Project 1 Comment 1
Project 2 Comment 2
Project 3 Comment 3
Project 4 Comment 4

I currently have some code that will open and pull from the new file. However, every time I update, the "project" column will likely not be the same as before; new projects will be added or some will be deleted. I need the comments to stay respective to each project but also account for when new projects might get added. Any ideas are welcome! Thank you.

[isskint]

The simplest way i can think is to make an addition to your code to transfer your comments to the new sheet BEFORE importing the data, and include your comments in the imported data.

something like this?

Please Login or Register  to view this content.