+ Reply to Thread
Results 1 to 4 of 4

need vba code to chance the value in G:G column depepends upon rule

  1. 02-07-2016, 11:51 AM #1
    MicroTees
    MicroTees is offline
    Forum Contributor
    Join Date
    06-10-2014
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    118

    need vba code to chance the value in G:G column depepends upon rule

    Dear sir

    I have list of data in G:G date and 0 i want change values where date show after 1-may-2015 change as 999 and whereever find 0 and NO Prior take value from F:F column

    rule1 : AFTER1-MAY-15 change as 999
    rule2 : NO Prior take value from =L

    find the attachment.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 02-07-2016, 12:24 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,696

    Re: need vba code to chance the value in G:G column depepends upon rule

    Try this:

    Please Login or Register  to view this content.

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 02-08-2016, 03:03 PM #3
    MicroTees
    MicroTees is offline
    Forum Contributor
    Join Date
    06-10-2014
    Location
    CANADA
    MS-Off Ver
    2016
    Posts
    118

    Re: need vba code to chance the value in G:G column depepends upon rule

    Thanks sir works perfectly!!!100% solved
    Reply With QuoteRegister To Reply
  4. 02-08-2016, 03:17 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,696

    Re: need vba code to chance the value in G:G column depepends upon rule

    You're welcome.
    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. How to adjust VBA code to create rule for a specific cell, rather than a whole column
    By jlax87 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-20-2015, 12:51 AM
  2. [SOLVED] Rule to find cells in column A that correspond to multiple values in column B
    By margaretanne in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-11-2013, 07:24 PM
  3. Setting validation rule using code
    By stoney1977 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-14-2007, 07:47 PM
  4. A better chance
    By leo31773 in forum Excel General
    Replies: 4
    Last Post: 09-13-2005, 10:54 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1