Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why I cannot import this link into excel? Eric Excel Discussion (Misc queries) 1 April 18th 08 11:39 PM
Import or link data? Nrippe Excel Worksheet Functions 0 March 29th 07 08:40 PM
update link Link Updates Excel Worksheet Functions 1 September 5th 06 05:55 PM
update a link to a CSV T Excel Discussion (Misc queries) 2 August 7th 05 09:00 PM
How do I import from Quickbooks and create a link. weclean Excel Worksheet Functions 7 April 6th 05 10:37 PM


All times are GMT +1. The time now is 06:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"