Macro that matches two Excel data and transfers data from one to the other "Effective Cell" series Matching macro (high speed version) for business use
EC Research Institute Co., Ltd.
EC Research Institute Co., Ltd.'s Response Status
This product is registered by EC Research Institute Co., Ltd..
About This Product
■Applications/Features
- General work to link multiple data.
- Transferring data to another workbook.
- Troublesome verification work.
- Combining multiple data tables.
- Ideal for those who do not understand VLOOKUP, XLOOKUP, spill, etc., or those who are anxious or troublesome.
- [High-speed processing] High-speed processing even with "unsorted data", "contains unmatched data", "multiple keys", and "between different books".
Features
■Fast processing
Because the macro is a DLL and the matching process is performed after analyzing the key structure and arrangement, high-speed processing is possible even when unsorted, including unmatched data, with multiple keys, and between different books. Possible.
■Various options can be specified to suit your needs
- Values can be transferred, mathematical formulas can be transferred, and formats can also be transferred.
・Various options are available, such as not forwarding blank fields and stopping screen updates.
■Understand the match status
・Display the match list and unmatch list on the sheet "Match status".
・You can see which data matched with which data, and which data did not match.
■Limit of margin
- Up to 100 columns can be specified for the key.
- Up to 100 information-added columns can be specified.
■Compared to standard VLOOKUP, XLOOKUP, Spill, etc., it is more complete and highly functional.
- Input support processing is enhanced and settings are easier to understand than standard.
・There is no need to enter formulas such as VLOOKUP and XLOOKUP in the cell or column that receives the transfer.
- Even if you change the target book, just change the settings screen.
・There is no need to change the formula even if the number of data items increases or decreases.
・It is necessary to spill and set a function for each column and each row, but that is not necessary.
・Even if the data changes, since it is a macro, it will not be updated without permission until you run it, so you can rest assured. (For formulas, they may be updated unintentionally if the data changes.)
- Even if there are many transfer destinations, updates from other books will not be slow (data that has many VLOOKUPs/XLOOKUPs embedded is very heavy, but with this macro, it will not be heavy), etc.
-
-
Product
Macro that matches two Excel data and transfers data from one to the other "Effective Cell" series Matching macro (high speed version) for business use
Share this product