![]() |
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