Merge Tables Wizard for Microsoft Excel makes finding and copying matching data in Excel worksheets a breeze. This handy vlookup add-in quickly merges two Microsoft Excel tables into one by matching values in corresponding columns. The two tables can be located in the same Microsoft Excel file or in two different Excel files. The intuitive and easy-to-understand wizard will guide you through the merge process. Rows from the two tables with different number of columns will be matched perfectly without copying and pasting.
To ensure that you get exactly the results you need, the Merge Tables Wizard provides a number of really wonderful features. For example, you can choose to have the rows that appear only in the lookup table added to the end of the master table (Number 3 in the picture below). You can add a status column that will reflect all changes made in your master table after merging. You can color updated cells so that you can see all changes at a glance, and more.
Features of Merge Tables Wizard for Microsoft Excel
– Find and merge matching data in seconds.
– Use one or several columns as matching criteria.
– Compare Microsoft Excel lists from different workbooks.
– Add new columns to the main table or update data in existing columns.
– Highlight updated data in color.
– Filter updated or non-updated columns.
Requirements:
– Microsoft Excel 2000
