Results 1 to 2 of 2

Add Code to compare Dates, then run macro to match colums

Threaded View

  1. #1
    Registered User
    Join Date
    09-24-2019
    Location
    SA. TX
    MS-Off Ver
    2010
    Posts
    1

    Add Code to compare Dates, then run macro to match colums

    Hi, Hope I can get some help with adding code to compare dates in column A of Sheet1 & Sheet2. If the date on Sheet2 is greater than Sheet1 run the MatchColumns macro.

    Sheet1 accumulates jobs with recommendations through out the year. Sheet2 accumulates completed recommendations. Any row on Sheet1 without a match needs to be followed up on. Duplications are appearing as highlighted on row 14. Since the job on row 14 took place on 1/24/19, the recommendation could not have been completed prior to that date. I've added the following;

    Sub CompareDates()
    
    If Sheet1.Range("A1") > Sheet2.Range("A1") Then
    Run "MatchColumns"
    End If
    End Sub
    But it's not working.

    Any help would be appreciated as I'm a very novice user.
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 09-25-2019 at 02:49 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. compare 2 colums and output match in thrid
    By hiranuk in forum Excel General
    Replies: 2
    Last Post: 04-29-2020, 10:53 AM
  2. [SOLVED] Use INDEX MATCH to return data between dates and get AVERAGE of values in two colums
    By Jay S. in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-01-2015, 08:59 PM
  3. Replies: 3
    Last Post: 12-07-2014, 11:30 AM
  4. Macro to compare two colums and copy rows if data matches.
    By avinash.aswani in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-11-2013, 03:03 AM
  5. MAcro to Compare two colums in different sheet and paste corresponding data.
    By avinash.aswani in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2013, 11:25 AM
  6. [SOLVED] Compare Colums and Color enire row if values (text) do not match
    By GatorsBucs in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-27-2013, 11:43 AM
  7. Replies: 2
    Last Post: 06-07-2012, 07:03 AM

Tags for this Thread

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