+ Reply to Thread
Results 1 to 2 of 2

Compare between 2 work sheets and post differences in different work sheets

  1. 08-25-2016, 11:16 AM #1
    Jimmy19
    Jimmy19 is offline
    Registered User
    Join Date
    08-25-2016
    Location
    irving
    MS-Off Ver
    2007
    Posts
    0

    Post Compare between 2 work sheets and post differences in different work sheets

    I need help in getting a macro which compares between 2 work sheets having <=100 columns in both sheet with same record count and post the sheet 1 difference in comparison to sheet 2 (sheet2 - sheet1) in sheet 3 and vice versa(sheet 2 difference in comparison to sheet 1) in sheet 4.

    Note: I am new to VBA, Macro, Excel formulas so please let me know the manual to trigger once the solution is posted.

    Any help would be appreciated. Thanks in advance for rescuing me!
    Reply With QuoteRegister To Reply
  2. 08-25-2016, 11:19 AM #2
    arlu1201
    arlu1201 is offline
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello Jimmy19,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. populate a list on one work sheet from multiple work sheets that meet a criteria
    By Kelly Linton-Selkirk in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 01-21-2015, 03:56 PM
  2. Formula required to compare names on two different work sheets
    By Spaz1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-13-2013, 05:59 PM
  3. Look up and compare value in two work sheets
    By wintheranders in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-17-2013, 04:43 AM
  4. Create PDF files from multiple work sheets in a single work book
    By erprasannaa in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-29-2012, 03:42 AM
  5. How to compare data from 2 sheets and put into a new work sheet
    By dtgheath in forum Excel General
    Replies: 7
    Last Post: 02-28-2009, 06:19 PM
  6. Copy rows from work sheets to combine to one work sheet based on cell value
    By joemcmillen in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-11-2008, 05:04 PM
  7. compare text and update different work sheets
    By mailboxsurya in forum Excel General
    Replies: 0
    Last Post: 05-06-2005, 10:31 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1