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

why not use VLOOKUP on sheet2 ?

"TK" wrote:

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,
How would I do Vlookup in Sheet2 to insert the new data from Sheet1? Please
advise.

"TK" wrote:

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