+ Reply to Thread
Results 1 to 4 of 4

Comparing values in two sheets

  1. 06-23-2022, 11:33 PM #1
    sgp86
    sgp86 is offline
    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
    Reply With QuoteRegister To Reply
  2. 06-24-2022, 12:33 AM #2
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,615

    Re: Comparing values in two sheets 

    Please Login or Register  to view this content.
    We live in a time where intelligent people are silenced so that stupid people won't be offended.
    Reply With QuoteRegister To Reply
  3. 06-24-2022, 12:57 AM #3
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,615

    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.
    Reply With QuoteRegister To Reply
  4. 06-25-2022, 12:04 AM #4
    jolivanes
    jolivanes is offline
    Forum Expert
    Join Date
    10-06-2008
    Location
    Canada
    MS-Off Ver
    2007 / 2013
    Posts
    4,615

    Re: Comparing values in two sheets

    Did you have a chance to try either one?
    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. [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. [SOLVED] Comparing cell values in different sheets based on multiple reference values as conditions
    By aknisha in forum Excel Formulas & Functions
    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. Comparing values from different sheets and inserting value from same row
    By thong in forum Excel Formulas & Functions
    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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1