Insert and Update data

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
 
T

TK

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top