Excel External Data Connection

Hello All,

In my workbook, I have several sheets that are linked to an outside data source.

In Column A, I have a primary piece of information. I have added a column in column B in which I add notes about column A. However, when I refresh the data source, my notes stay in column F, but not in the same row as column A.

Is this a good enough of a description to where you understand my problem?

I need my notes to stay static with column A after a refresh.

Without a sample file I will have to assume some things. Your primary data is unique and that you want your comments to stay with the appropriate primary data entry. I would write some code to take a temporary copy of column A and B and paste it into a new sheet called Temp. I would then refresh the data set. Then go back to the data and in column B add a Vlookup() to retrieve the comments from the temp copy. Then copy and paste as values the comments and delete the temp sheet.

without a sample sheet to work with I won't try the code you would have too many changes to make. It sounds a bit long winded but it will keep your comments linked to the correct primary data values.

I work with external data queries everyday and I do things like this a lot.

JimBobBowie