All Categories

History

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-Matching macro (high speed version) for business
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.

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

Response Rate

100.0%

Response Time

0.3hours

Very Fast Response


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


50+ people viewing

Last viewed: 4 hours ago


Free
Get started with our free quotation service - no cost, no obligation.

No Phone Required
We respect your privacy. You can receive quotes without sharing your phone number.

1 Models of 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

Image Part Number Price (excluding tax)
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-Part Number-Matching macro (high speed version) for business

Matching macro (high speed version) for business

Available upon quote

Customers who viewed this product also viewed

Reviews shown here are reviews of companies.

See More Document Management Software Products

Other products of EC Research Institute Co., Ltd.

Reviews shown here are reviews of companies.


View more products of EC Research Institute Co., Ltd.

About Company Handling This Product

Response Rate

100.0%


Response Time

0.3hrs

  • Japan

This is the version of our website addressed to speakers of English in the United States. If you are a resident of another country, please select the appropriate version of Metoree for your country in the drop-down menu.

Copyright © 2024 Metoree