Updating many worksheets at one go is now possible with the Merge Several Tables with Single Lookup Table tool. It works in much the same way as Merge Two Tables but provides an opportunity to process numerous tables at once:
Besides, you can save your merge scenarios and run them at the click of a mouse.
Pay attention to the points below:
On the Ablebits Data tab, in the Merge group, click Merge Tables > Merge Several Tables with Single Lookup Table:
Almost all the steps to be followed are described on our help page for Merge Two Tables. Also, consult the hints available in the tool itself. To see a hint, simply hover the cursor over a blue circled question mark in the add-in's window:
To update all the necessary main tables, check off the worksheets that contain them in Step 6 of the add-in:
The tool can memorize the tables and options you select while working with it and keep them as a scenario. A saved scenario makes it possible to automatically reproduce all the steps and quickly update all specified tables with the required values from the selected lookup table taking into account the enabled options.
To get a scenario created, click the Save scenario button in Step 7 of the add-in:
You will be asked to name your scenario. When you are done, click OK.
After saving your scenario, you can access it at any time. Just start the Merge Several Tables with Single Lookup Table tool and the list of available scenarios will show.
To run the scenario of interest, select it in the list, decide which worksheet to use as the lookup table, and click Start:
To delete a scenario that you do not need anymore, select it in the list and click the Delete this scenario icon on the right of the scenario name.