Hi all,
sorry if this was covered already but I couldn't find a thread that matches my problem.
Basically I have two documents, they are both the same file basically, but one is an update on the other.
The info inside is a list of values (usually text but sometimes is numbers - a string table for a piece of software using text if you're interested).
Each cell with a piece of valuable data is catalogued with a reference name or number (an ID).
The layout is very simple:
The ID is in Col A, and the data is in B. So it might look like:
ID | Data
1a | John
2b | Clare
3c | Stephen
What I do is update the data in Col.B for any errors, then highlight the cell in a colour. Problem is that midway through this job I get an updated file with new lines and I have to merge the data to the correct place in the new file.
So for eg. , lets say I edited line 2b in file 1 from the above to:
ID | Data
1a | John
2b | Clairé
3c | Stephen
Then I get a new file and the latest version looks like:
ID | Data
1a | John
2bx | Sam
2b | Clare
3c | Stephen
So I can't just copy paste the whole column, as the lines have moved essentially. Is there a way of getting Excel to check each cell, see if I have highlighted it green then copy paste it to the row with the right ID?
Thanks in advance! PS I've used Excel a fair amount, but never anything very complicated formula wise (never created a Maco for eg.)
sorry if this was covered already but I couldn't find a thread that matches my problem.
Basically I have two documents, they are both the same file basically, but one is an update on the other.
The info inside is a list of values (usually text but sometimes is numbers - a string table for a piece of software using text if you're interested).
Each cell with a piece of valuable data is catalogued with a reference name or number (an ID).
The layout is very simple:
The ID is in Col A, and the data is in B. So it might look like:
ID | Data
1a | John
2b | Clare
3c | Stephen
What I do is update the data in Col.B for any errors, then highlight the cell in a colour. Problem is that midway through this job I get an updated file with new lines and I have to merge the data to the correct place in the new file.
So for eg. , lets say I edited line 2b in file 1 from the above to:
ID | Data
1a | John
2b | Clairé
3c | Stephen
Then I get a new file and the latest version looks like:
ID | Data
1a | John
2bx | Sam
2b | Clare
3c | Stephen
So I can't just copy paste the whole column, as the lines have moved essentially. Is there a way of getting Excel to check each cell, see if I have highlighted it green then copy paste it to the row with the right ID?
Thanks in advance! PS I've used Excel a fair amount, but never anything very complicated formula wise (never created a Maco for eg.)
