View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FirstVette52 FirstVette52 is offline
external usenet poster
 
Posts: 37
Default Import link update filtering

I have a .csv that gets updated weekly with new information. It is linked
into a Spreadsheet. I would like to add a column to the data for 'Comments',
but here's the challenge:

Each time the Spreadsheet gets updated, I want to replace the data with the
new data BUT I want to keep the 'Comments' with the appropriate records (if a
record is deleted in the new Data, I want the 'Comment' also deleted, but if
the record comes in again with the Refresh, then I want it to appear with it).

Any ideas? I thought about a new Spreadsheet linked to the Import-linked
sheet, but that's where my head starts spinning. I'm not very good at this.

Thx! Doug
--
FirstVette52