Scan two sheets for the same values based on key columns and update your main table with the missing information.
Five simple steps of the Merge Sheets wizard will guide you through the process of joining data from two tables. If you have at least one common identifier column in both sheets, e.g. product ID, the add-on will insert all the missing information for the same records in your main table.
- Select the table you want to update and the one to pull information from
- Define common columns the add-on can use to find the same records
- Choose the columns to update or add to your main sheet
The merge assistant will do the rest. It will quickly compare key columns and find the necessary updates, no vlookup formulas needed. You can highlight changes with color, work only with the empty cells, and have all new records added to the end of the table. When the merge is complete, you'll see the summary of all changes that the add-on has made.
You can use this tool whenever you need to compare two sheets and bring the latest changes to your table.
If you have any questions about the add-on, please post them in our community: http://goo.gl/5aqwsD