Keep comments column correct after refreshing data columns

[treva26]

I have an worksheet that refreshes every day from a .csv report.
I would like to be able to have a comments column at the end that users type in.
The problem is how to keep the comment next to the row it was on before the refresh.

When it refreshes there will be new rows, rows that are no longer there and all in a different order.

There is an Order Number column that can be used as an ID column.

I am not sure of the best way to go about doing this.
Any thoughts would be appreciated.

[dogberry]

Hi

Can you post a sample worksheet so we can see the layout etc dont post confidentail information


To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the Browse... button to locate your file for uploading.
6. This will open a new window File Upload.
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the Upload button and wait until the file has uploaded.
10. Close the window and then click Submit.



Chris

[treva26]

Here is an example workbook.

I would set it to refresh the data on open.

Thanks.

[treva26]

The best idea I have come up with so far:

Before refreshing the table, a vba sub copies as values the ID and Comments columns to another location.
Table refreshes.
vba copies and pastes as values from a hidden lookup column that uses the saved values from step 1.

See new workbook.