With Ablebits.com Merge Tables Wizard you can lookup and combine matching data from 2 Excel worksheets in seconds. The add-in is an easy-to-understand alternative to Microsoft Excel Lookup and Vlookup functions. It perfectly merges matching data from two tables whether they are located in the same or in two different Microsoft Excel files. The intuitive and smart wizard provides a step-by-step guidance through the join process while additional capabilities and advanced options of the add-in ensure exactly the results Excel users need. Those who do a lot of data analysis in Excel will definitely appreciate the following capabilities of the Merge Tables Wizard: - Ability to find and copy matching data in seconds. - Auto-detecting all matching columns. - Using one or several columns as matching criteria. - Comparing Excel lists from different workbooks. - Adding new columns to the main table or updating values in existing columns. - Highlighting updated data in any color. - Updating only empty cells so that the existing content won't get overwritten. The add-in works in all versions of Microsoft Excel from 2003 to 2013 (32- and 64-bit). Get started with a free download at http://ablebits.com/mergeexcel
VERSION HISTORY
- Version 1.6.9 posted on 2008-09-25
FIXED: "Application.InputBox returns value of unexpected type." error if the worksheet contained Conditional Formatting with the "Formula Is" condition.
Program Details
- Category: Business > Office Suites & Tools
- Publisher: Add-in Express Ltd.
- License: Free Trial
- Price: $49.95
- Version: 3.1.4
- Platform: windows
EULA
Add-in Express Ltd. End-User License Agreement You should carefully read the following terms and conditions before installing the software. By installing the software you indicate your acceptance of these terms and conditions. This Add-in Express Ltd. ("ADD-IN EXPRESS") End-User License Agreement ("EULA") is a legal agreement between you, either an individual or a single entity ("USER"), and ADD-IN EXPRESS LTD. for all ADD-IN EXPRESS SOFTWARE identified above and including computer software and associated media, printed materials, and "online" or electronic documentation ("SOFTWARE") contained in this installation file. ADD-IN EXPRESS grants to you as an individual, a personal, nonexclusive license to install, use, access, display, run, or otherwise interact with ("RUN") one copy of the SOFTWARE, or any prior version for the same operating system, on a single computer, workstation, notebook, or other digital electronic device ("COMPUTER") for a single user. If you purchased a license of the SOFTWARE marked “For Installation on Terminal Server”, ADD-IN EXPRESS grants to you as an individual, a personal, nonexclusive license to install, use, access, display, run, or otherwise interact with ("RUN") one copy of the SOFTWARE, or any prior version for the same operating system, on a single Terminal Server or a Terminal Servers Farm for a single user. If you are an entity, you must designate one individual within your organization to license the right to use the SOFTWARE in the manner provided herein. By installing, copying, or otherwise using the SOFTWARE, you agree to be bound by the terms of this EULA. If you do not agree to any part of the terms of this EULA, DO NOT INSTALL, USE, DISTRIBUTE IN ANY MANNER, OR REPLICATE IN ANY MANNER, ANY PART, FILE OR PORTION OF THE SOFTWARE. Immediately return it to place of purchase for a full refund. RIGHTS Installing the SOFTWARE. You may install and use one copy of the SOFTWARE, or any prior version legally licensed for the same operating system, on a single COMPUTER for a single user. If you need to install the SOFTWARE on a Terminal Server, you should obtain a license of the SOFTWARE marked “For Installation on Terminal Server”. If you have such a license, you may install and use one copy of the SOFTWARE on a single Terminal Server or a Terminal Servers Farm for a single user. The SOFTWARE cannot be used on systems such as terminal servers for shared usage. Transferring the SOFTWARE. You may transfer all of your rights to use the SOFTWARE to another person, provided that you transfer to that person all of the software, diskettes (if applicable), and documentation provided in this package (including this license agreement), and transfer or destroy all copies in any form. Remember, once you transfer the software, you no longer have any right to use it, and the person to whom it is transferred may use it only in accordance with the copyright law, international treaty, and this license. Upgrading the SOFTWARE. If you have purchased an upgrade for the Software, the original product together with the upgrade constitute a single license. The original Software and the upgrade Software cannot both be available for use by two different people at the same time, and cannot be transferred separately without written permission from ADD-IN EXPRESS. RESTRICTIONS Limitations on Reverse Engineering, Decompilation, and Disassembly. You may not reverse engineer, decompile, or disassemble the SOFTWARE, except and only to the extent that such activity is expressly permitted by applicable law notwithstanding this limitation. Separation of Components. The SOFTWARE is licensed as a single product. Its component parts may not be separated for use on more than one COMPUTER. Trademarks. This EULA does not grant you any rights in connection with any trademarks or service marks of ADD-IN EXPRESS. Rental. You may not rent, lease, or lend the SOFTWARE. Copyright. All title and copyrights in and to the SOFTWARE (including but not limited to any images, demos, source code, intermediate files, packages, photographs, distributables, animations, video, audio, music, text, and "applets" incorporated into the SOFTWARE the accompanying printed materials, and any copies of the SOFTWARE) are owned by ADD-IN EXPRESS or its subsidiaries. The SOFTWARE is protected by copyright laws and international treaty provisions. Therefore, you must treat the SOFTWARE like any other copyrighted material except that you may install the SOFTWARE on a single computer provided you keep the original solely for backup or archival purposes. You may not copy the printed materials accompanying the SOFTWARE. LIMITED WARRANTY NO WARRANTIES. ADD-IN EXPRESS expressly disclaims any warranty for the SOFTWARE. THE SOFTWARE AND ANY RELATED DOCUMENTATION IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESS OR IMPLIED, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, OR NONINFRINGEMENT. THE ENTIRE RISK ARISING OUT OF USE OR PERFORMANCE OF THE SOFTWARE REMAINS WITH YOU. To the maximum extent permitted by applicable law, in no event shall ADD-IN EXPRESS be liable for any special, incidental, indirect, or consequential damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or any other pecuniary loss) arising out of the use of or inability to use the SOFTWARE or the provision of or failure to provide Support Services. MARKETING You agree to be identified as a customer of ADD-IN EXPRESS and agree that ADD-IN EXPRESS may refer to you by name, trade name and trademark, if applicable, and may briefly describe your business in ADD-IN EXPRESS's marketing materials and web site. You hereby grant ADD-IN EXPRESS a license to use your name and any of your trade names and trademarks solely in connection with the rights granted to ADD-IN EXPRESS pursuant to this marketing section. If this clause breaches your company policy or you do not wish to be bound by this clause, ADD-IN EXPRESS should remove it upon your request. SUPPORT SERVICES ADD-IN EXPRESS may provide you with support services related to the SOFTWARE ("Support Services"). Use of Support Services is governed by the ADD-IN EXPRESS policies and programs described in the user manual, in "on line" documentation and/or other ADD-IN EXPRESS-provided materials. Any supplemental SOFTWARE code provided to you as part of the Support Services shall be considered part of the SOFTWARE and subject to the terms and conditions of this EULA. With respect to technical information you provide to ADD-IN EXPRESS as part of the Support Services, ADD-IN EXPRESS may use such information for its business purposes, including for SOFTWARE support and development. ADD-IN EXPRESS will not utilize such technical information in a form that personally identifies you. CUSTOMER REMEDIES ADD-IN EXPRESS's and its suppliers' entire liability and your exclusive remedy shall be, at ADD-IN EXPRESS's option, either (a) return of the price paid, if any, or (b) repair or replacement of the SOFTWARE that does not meet ADD-IN EXPRESS's Limited Warranty and which is returned to ADD-IN EXPRESS with a copy of your receipt. This Limited Warranty is void if failure of the SOFTWARE has resulted from accident, abuse, or misapplication. Any replacement SOFTWARE will be warranted for the remainder of the original warranty period or thirty (30) days, whichever is longer. MISCELLANEOUS You may not sublicense, assign or transfer the license of the SOFTWARE. Any attempt to sublicense, assign or transfer any of the rights, duties or obligations hereunder is void. This agreement will be governed by the laws of the Republic of Belarus. Should you have any questions regarding this agreement, you may contact ADD-IN EXPRESS by writing to Add-in Express Ltd.., 149 Barykina Str., Gomel, 246000, Republic of Belarus. YOU ACKNOWLEDGE THAT YOU HAVE READ THIS AGREEMENT, UNDERSTAND IT AND AGREE TO BE BOUND BY ITS TERMS AND CONDITIONS. YOU FURTHER AGREE THAT IT IS THE COMPLETE AND EXCLUSIVE STATEMENT OF THE AGREEMENT BETWEEN US, WHICH SUPERSEDES ANY PROPOSAL OR PRIOR AGREEMENT, ORAL OR WRITTEN, AND ANY OTHER COMMUNICATIONS BETWEEN US RELATING TO THE SUBJECT MATTER OF THIS AGREEMENT. Copyright (C) 2002-2013 ADD-IN EXPRESS LTD. All rights reserved.