Insert and Update data

  • Thread starter Thread starter TK
  • Start date Start date
T

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
 
Back
Top