Results 1 to 22 of 22

Compare data with different workbooks

Threaded View

ccs1981 Compare data with different... 10-11-2008, 06:58 AM
ccs1981 can some1 please help me? 10-12-2008, 09:40 PM
rylo Hi This is pretty basic,... 10-12-2008, 10:16 PM
ccs1981 thanks 10-15-2008, 09:51 PM
ccs1981 is it i need do a for loop to... 10-15-2008, 09:54 PM
  1. #1
    Registered User
    Join Date
    09-16-2008
    Location
    malaysia
    Posts
    89

    Compare data with different workbooks

    Good days,

    i had received a new project. i want to compare the data among 2 different workbooks.
    there are book1 and book2 which i attach at here.
    if there are 1 cells is different with both workbooks, then the whole row will copy and paste to a new workbook "output.xls".

    i also attach the "output.xls" at here.

    the background color i highlighted which data is different, just for easy to view. so can ignore the color.
    can someone help me please...
    Attached Files Attached Files
    Last edited by ccs1981; 10-24-2008 at 11:45 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Compare data in worksheets
    By ransnooky in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-16-2008, 07:15 AM
  2. Charts that call data from a variable number of workbooks?
    By Schwavan in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-11-2008, 12:31 PM
  3. Displaying data from other workbooks matching a criteria
    By jpruffle in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-10-2008, 11:16 AM
  4. [SOLVED] Workaround to retrieve data from closed workbooks by using formulas.
    By all4excel in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-08-2008, 08:06 AM
  5. create multiple workbooks based on data in worksheet
    By mpreddy in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-11-2007, 12:16 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1