Import an Excel file while maintaining alignment with the user comment column

As an avid and devoted follower and subscriber to your YouTube channel, I've always admired the insights you share. Today, I'm reaching out for the first time with a challenge. I believe your expertise could help me navigate.

Your tutorials have significantly elevated my skills as an average Excel and VBA user, particularly in the realm of analyzing and crafting dashboards for my team. Your guidance has been invaluable, and I now turn to you with a specific issue. I am analyzing and creating dashboards for my team, and your videos have been instrumental in helping me build more robust, dynamic, and user-friendly dashboards.

I am writing to seek your expertise on a specific problem I�m encountering. My data model involves a file with over 10,000 rows and 28 columns, and I import this sizable data set every week for my team to review and make necessary comments and modifications. The columns/headers are constant. Given the limited number of licenses to access the data on the server, I download the data file weekly so that the team can keep current with each of the tasks.

The enclosed file is a representation of my data model with fewer columns and rows. The enclosed table tries to simulate the problem I have.
The challenge arises when new data is imported, as it tends to overwrite the existing data, excluding team comments that are located outside the table range. This results in misaligned comments when additions or removals occur in the master file. Also, not knowing if the updates from the previous week have been updated on the server.
To address this issue, I am seeking a method that accomplishes the following:
Preserves user comments and aligns them with the correct line item when new data is imported.

Highlights any modifications made by users to the previous file in any of the data fields that have not been updated on the server.

I am hopeful that you can provide guidance or suggestions on how to achieve these objectives. Your expertise has been invaluable to me thus far, and I eagerly anticipate your insights on this matter.

Thank you for considering my request, and I look forward to hearing from you soon. Please let me know if you have any questions.
?*
Best Regards,
pivotsmoak

crosspost: https://www.mrexcel.com/board/thread...olumn.1250552/

Rule 7: Cross-posting Without Telling Us

Your post does not comply with Rule 3 of our Forum RULES. Do not cross-post your question on multiple forums without telling us about your threads on other forums.

Post a link to any other forums where you have asked the same question.

Cross-posting is when you post the same question in other forums on the web. The last thing you want to do is waste people's time working on an issue you have already resolved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser) to the cross-post.

Read this to understand why we ask you to do this.

I have added the crosspost reference for you today. Please comply with this and all our rules in the future

However, if you continue to crosspost, you can expect to have your thread BLOCKED until you update it yourself.