Results 1 to 5 of 5

VBA Code To check the valid partnername and date in H&M column

Threaded View

johnlara VBA Code To check the valid... 06-30-2016, 03:20 PM
CAntosh Re: VBA Code To check the... 06-30-2016, 04:39 PM
johnlara Re: VBA Code To check the... 07-01-2016, 01:08 AM
CAntosh Re: VBA Code To check the... 07-01-2016, 09:58 AM
johnlara Re: VBA Code To check the... 07-17-2016, 11:41 PM
  1. #1
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    VBA Code To check the valid partnername and date in H&M column

    Dear expert



    I have set of data which is combined with multiple partner name
    i want find which are partner name wrongly updated in H:H by look up of pudo code in E2, from pudo list(sheet2)


    I want check for the pudo exact partner name is updated in H:H if not updated as per list. towards O:O column i want remarks as Wrong Partner Name
    i want check in M:M column formula IF(OR(J2>=DATEVALUE("06/30/2015"),J2=0),I2,"999") which should have date of 06/30/2015 which are not exact date towards N:N column i want remarks as "Wrong Date Updated"


    find the attachment you may understand what actually i looking for
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Check Date Format Input into Excel Column with VBA code
    By stanlelma in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 01-20-2024, 03:27 AM
  2. Valid email id check
    By luxmraj in forum Excel General
    Replies: 5
    Last Post: 11-09-2021, 12:51 PM
  3. Edit code to loop error msgbox and inputbox until valid date is entered by user.
    By rocksan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-11-2012, 10:07 PM
  4. check if email (provider) is valid
    By Armitage2k in forum Excel General
    Replies: 0
    Last Post: 06-03-2011, 11:39 AM
  5. Check for Valid Sheet Name
    By degmania in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 05-21-2008, 11:13 PM
  6. How to check valid Date value?
    By hstijnen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-14-2006, 08:30 AM
  7. What's the most efficient to check a file name is valid?
    By Dave Peterson in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-02-2005, 10:10 PM
  8. Check if date is valid
    By Lava in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-19-2005, 10:28 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