+ Reply to Thread
Results 1 to 4 of 4

Comparing values in two sheets

  1. #1
    Registered User
    Join Date
    06-23-2022
    Location
    Bangalore, India
    MS-Off Ver
    office 365
    Posts
    1

    Comparing values in two sheets

    I need a macro to compare two sheets(values of particular column in the sheets) in a workbook and display the value in another sheet if the value is lesser than the other. Please guide me

  2. #2
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Comparing values in two sheets

    Please Login or Register  to view this content.
    Experience trumps academics every day of the week and twice on Sunday.

  3. #3
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Comparing values in two sheets

    Another way that should be faster on very large ranges.
    For both suggestion, change references as required.
    Please Login or Register  to view this content.

  4. #4
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    5,498

    Re: Comparing values in two sheets

    Did you have a chance to try either one?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] entering values by comparing two sheets
    By Rockergal in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-07-2016, 10:50 AM
  2. [SOLVED] Comparing time values in 2 different sheets
    By PrestonT in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 08-15-2016, 04:59 PM
  3. Replies: 1
    Last Post: 10-01-2013, 02:41 AM
  4. Comparing 2 sheets and highlighting completed values
    By norrillous in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-05-2013, 02:44 AM
  5. Comparing values in two columns on two sheets
    By aaronhallstrom in forum Excel General
    Replies: 2
    Last Post: 06-10-2011, 04:39 PM
  6. Replies: 1
    Last Post: 02-17-2010, 06:56 PM
  7. comparing values in two sheets of same workbook
    By xindaiel in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-07-2008, 06:35 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