Say, you need to compare two Excel
spreadsheets, find the updates or new columns and get them to your main table
for further analysis. The problem is it's too time-consuming and doesn’t
guarantee that all the important data are included.
MergeTables Wizard for Microsoft Excel is a handy
alternative to Excel Lookup and Vlookup functions that will automatically
compare 2 sheets you specify as master and lookup, uncover matching rows and
update your first table. All it takes is five steps and less than a minute.
In addition, you can use one or several
columns as matching criteria, add new columns to the main table or update the
existing ones, highlight or filter the modified entries.
How Merge Tables Wizard works
Forget about manual checking of two Excel
tables for matching data!
- You just select the Master Table - the one that you want to update.
- Choose the Lookup Table where the add-in will look for the new data.
- Pick matching columns or those with common index fields in both spreadsheets.
- Choose the columns to be updated or added to the main table.
- Adjust the merge results using additional options on the last step.
Finishing touch to the merge results
There are some additional options that you
may find useful. For matching rows
this tool will set the background color of updated cells, update only empty
cells in your main table or update only if cells from the lookup table contain
data.
Also you can tweak the following options
for non-matching rows: Clear
background colors of Non-updated cells or Add non-matching rows to the end of
the Master Table.
You can also mark the merged data by adding
a status column to the master table that will indicate rows as: Updated,
Non-updated or New row. Take the advantage of this option if you want to have
this information at hand even after sorting the rows or changing the layout of
your worksheet.
Use Merge Tables Wizard to join data from
different sources, find and merge matching data
from two Excel tables in seconds.
No hay comentarios:
Publicar un comentario