Update table records tool
GUI Tool for joining data from different Excel files.
IMPORTANT!!! You will not be able to UNDO merge operation!!! Use this tool very carefully!
Very common managerial task: need to merge several tables into one to get consolidated information
In this case, you can think of each row of these tables as a record, and for consolidation purposes, the columns of these records can be divided into two groups:
ID columns - The combination of data in these columns is unique to these workbooks (e.g. for the example above it can be columns A and B, which together create a unique Manager-Client "address" for each record).
Data columns - Columns containing data to be consolidated (column C for workbooks A and C and column D for workbook B).
Run UpdateTableRecordsFromOtherWorkbooks() macro to open special consolidation form, which will help you to do this kind of operations.
