Insert and Update data

[TK]

In Excel how do update data from Sheet1 to Sheet2 when there's a change in
Column B(sheet1) and add a new row if there's new data.

Example: Sheet1 Column A Column B
Name Grade
John B
Adam C

Sheet2 Column A Column B
Name Grade
John C
End result Sheet2 should be John grade change from C to B and add Adam/C to
the next row.

Thanks in advance for all the help

 

[Patrick Molloy]

why not use VLOOKUP on sheet2 ?

 

[TK]

Patrick,
How would I do Vlookup in Sheet2 to insert the new data from Sheet1? Please
advise.