Populate sheet with rows from the other sheet
Do you need to update your table with records from another sheet?
Here is what you need to do, to populate right worksheet with rows from the left one:
-
Compare two excel sheets
-
Select the Merge tab on the ribbon
-
Click the Insert Rows from Left button