Must Have | TOP 100 | Authors | Reviews | RSS | Submit

Recommended Software

The Bat!

The Bat! 3.95

The Bat! is a powerful, highly configurable, yet easy to use, email client for the casual user or the power user, the home or the office. Unlimited multiple accounts and multiple users Familiar Explorer-style folders for organizing messages Easily configurable user interface with message...

DOWNLOAD
 
 

Excel List Compare

Excel List Compare 1

Category: Business & Productivity Tools / Database Management | Author: PSP

This useful Excel macro will compare rows in 2 lists of data based on 1 to 3 columns in each list. Creates a new spreadsheet with matched rows from original 2 lists merged together on the same row and unmatched rows highlighted on seperate rows.

DOWNLOAD Cost: $0.00 USD
License: Freeware
Size: 48.2 KB
Download Counter: 1928

Useful Excel macro will compare rows in 2 lists of data based on 1 to 3 columns in each list. Creates a new spreadsheet with matched rows from original 2 lists merged together on the same row and unmatched rows highlighted on separate rows.
As the 2 lists of data are merged into a one spreadsheet, the number of columns of the 2 lists together must not exceed the maximum number of columns Excel supports.
Tested on MS Office 97 - XP.

Requirements: MS Excel 97 or higher
OS Support: Windows 3.x, Windows 95, Windows 98, Windows Me, Windows NT, Windows 2000, Windows XP, Windows 2003
Language Support: English

Released: December 01, 2004 | Added: December 04, 2004 | Viewed: 17837
 

Related Software

Compare Lists | Excel | Excel Compare | Excel fft macro | Excel File Compare | Excel Macro | Excel macro pda | Excel pim macro | Excel tga macro | Macro | Macro excel pda | Tts excel macro

  • Excel Macro Processor Icon Excel Macro Processor - Excel Macro Processor allows you to apply Excel macros to a lot of MS Excel files (.xls) at a time. You can use useful macros from our library or add your own macros. Develop solutions of automation for your business based on Excel macros and VBA.
  • Excel Compare Data in Two Tables Software Icon Excel Compare Data in Two Tables Software - Compare 2 separate blocks of Excel cells and find differences between them. Comparison results explain which cells were changed and which rows have been added or deleted. There is a feature for finding matches between two blocks of cells.
  • Workspace Macro Icon Workspace Macro - Ease your workload. Delegate repetitive tasks to Workspace Macro Recorder. Keyboard macro, mouse macro. SMART Macro Technology ensures high reliability. Simple, intuitive, user-friendly. Just record & replay. Macro recorder, Macro program.
  • Excel Compare Icon Excel Compare - Track differences and compare Microsoft Excel files and spreadsheets with Excel Compare. Excel Compare saves time by eliminating the file comparison routine, and improves comparison precision by telling you exactly what and where has been changed.
  • Select to Excel Icon Select to Excel - This small Excel macro allows you to execute SQL commands on any ODBC data source directly in Excel and will paste the results in an Excel sheet where you can sort, filter and further manipulate the data.
  • Workspace Macro Pro - Automation Edition Icon Workspace Macro Pro - Automation Edition - Automate & schedule tasks easily. Reliable macro program & Windows automation software with task scheduler. Record keyboard & mouse, use the macro editor or create macros using pre-defined macro templates. Easy to use macro recorder & Windows macro.
  • Easy Macro Recorder Icon Easy Macro Recorder - Easy Macro Recorder is a handy utility that makes your computers automatically do work for you. It records all operation of mouse and keystrokes and saves them as macros, then Easy Macro Recorder can play back recorded macros to automate your work.
  • Alerts for Microsoft Excel Icon Alerts for Microsoft Excel - Spinnaker Alerts 2.264 is an Excel Add-in that Alerts you to critical values in your worksheet by means of audio, pop-up messaging, E-mail paging, macro execution, and logging in Microsoft Excel 97 and later. Sample file included for a quick start
  • No Icon Smack - Record keystrokes and mouse events for playbacking later,you can also export any macro to Executable Macro file which run without Smack
  • Synkronizer Icon Synkronizer - Synkronizer is a powerful and user friendly Excel tool, that compares, updates and synchronizes Excel sheets and Excel data bases. Synkronizer performs the following functions: 1. mark deviations, 2. create a difference report, 3. update Excel files
 

Actual Software | Link To Us | Links | Contact

Must Have | TOP 100 | Authors | Reviews | RSS | Submit