Update data in row from Input sheet

[RicktheBlade]

Update only changes to a row from an input table



Hi, I am resonably new with excel formulas and VBA, and require a little help please?

On !Sheet1, I have a varity of cells with validations to choose the certain criteria. Once cells are selected I have an add button running on a macros that pulls the data to a single row in !Sheet2 and clears my selections on !Sheet1. If I enter more input on !Sheet1, this data will be added to the row beneath the previous on !Sheet2.

Some of this information consists of names and staff numbers (unique).

I want to make this input sheet (!Sheet1) check to see if the staff number exsists in !Sheet2 and update only what has changed in that row. Currently it is creating a new row (duplicating data).


Any help appriceiated

Thanks
Rick

[patel45]

a sample file will be appreciated

[kate.middleton1]

Hello Patel can you also please take a look at this thread too, because you have write this macro for me i just need little modification.
http://www.excelforum.com/excel-prog...omparison.html