ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Merging new data with old data (https://www.excelbanter.com/excel-discussion-misc-queries/216377-merging-new-data-old-data.html)

Vaelos

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

Vaelos

Merging new data with old data
 
bump

Bob I

Merging new data with old data
 
Sorry, this is actually a newsgroup which you are accessing through a
web based interface. "bump" has no meaning, and you neglected to quote
the original.

Vaelos wrote:

bump



Vaelos

Merging new data with old data
 
thank you for the useless reply.

"Bob I" wrote:

Sorry, this is actually a newsgroup which you are accessing through a
web based interface. "bump" has no meaning, and you neglected to quote
the original.

Vaelos wrote:

bump




Bob I

Merging new data with old data
 
Wasn't useless, you are now aware the use of "bump" is useless. Have a
good day.

Vaelos wrote:
thank you for the useless reply.

"Bob I" wrote:


Sorry, this is actually a newsgroup which you are accessing through a
web based interface. "bump" has no meaning, and you neglected to quote
the original.

Vaelos wrote:


bump






All times are GMT +1. The time now is 04:32 PM.

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