I manually reduced rows in sheet, how update the reduced sheet based on change to original

[Davefromlondon]

Hi
I have a sheet of 500 rows, I manually reduced it to 100 rows using my judgement of what rows I wanted to keep. The columns remained the same.
I received a new version of the original sheet and it has 1 extra column
How do I add the new column data, from the new version of 500, automatically, to the reduced sheet of 100 rows ?

[Eastw00d]

Hi, welcome to the forum,
if you have a unique identifier for each row, which is also in the new workbook/sheet, then you could do this with a VLOOKUP function.

Having said this, if you want detailed help, please read the yellow banner on top of this page.

Cheers
Erwin