Comparing two columns and adding the unique values to one of these

[JenniTee]

Hello,
I have a source excel file, that consists of some 15 columns and of approx. 4000 rows. For my table on another sheet I need the data in 5 of these columns, of which one is a unique ID for the row. I can use Vlookup to do this. There is some manually filled columns on this table, too.
The source file is updated monthly, and each time it is, I need to compare the unique ID column to the one I have in my table to see if there are changes. Also I want to add the new values to the bottom of my table. How can do this? Any tips?

I will add an example file: first sheet "Room list" is the montly updated source table, in which "Room number" is unique ID, and on the other sheet "Schedule" is my table which uses vlookup.

Thanks in advance!

[AliGW]

Jenni - is this the same thing you asked here back in August?

https://www.excelforum.com/excel-gen...l-columns.html

[JenniTee]

Hi,

It is related to the same problem, but this is a different approach to it, and a different question, even though the file is the same.