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
|