ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Import link update filtering (https://www.excelbanter.com/excel-discussion-misc-queries/189933-import-link-update-filtering.html)

FirstVette52

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


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com