The Merge Single Table with Several Lookup Tables tool updates the main table fetching the necessary records from numerous lookup tables with a few mouse clicks.
It can also keep merge scenarios and process your data automatically when needed.
Before running the add-in, here are the key points to take note of:
On the Ablebits Data tab, in the Merge group, click Merge Tables > Merge Single Table with Several Lookup Tables:
You can choose worksheets containing the necessary lookup tables in Step 6 of the add-in:
If a row with the same key value is present in several lookup tables, the main table will be updated with the data from each of them consecutively in the order you see the lookup tables on the list in Step 6. In the end, the updated columns of the main table will contain the values brought from the table that is the last of those lookup tables.
Selected tables and options can form a scenario of your choice. If you save and run it, the add-in will bring the necessary data from the selected lookup tables to the specified main one considering the options enabled and you need not go through all the steps anew.
To make the add-in memorize the tables and options you selected, click the Save scenario button in Step 7:
Then enter the name of your scenario and click OK.
Once your scenario is saved, it will be shown each time you run the tool.
To get your main table updated, select a scenario, decide which worksheet to use as the main table, and click Start:
If you do not need any of your saved scenarios, simply remove it from the list by clicking the Delete this scenario icon on the right of the scenario name.
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!