View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Vaelos Vaelos is offline
external usenet poster
 
Posts: 3
Default Merging new data with old data

Greetings,

Periodically, I get a set of data. I want to add a column with text that
describes said data, but when I get a new batch of data, it will not line up
as the values may have shifted around. How can I refer to my "master" copy"
and add the text into the new data, leaving blanks for data that hasn't been
described yet?

Example: data comes in, C:1= 175 (basically a unique number) - I create D:1
and type "Good"

data comes in, but C:1 is now C:87, but I still want D:87 to say "Good"

Hope that's clear, thanks for any help