Results 1 to 8 of 8

change value

Threaded View

fatalcore change value 09-15-2012, 04:42 AM
patel45 Re: change value 09-15-2012, 05:56 AM
fatalcore Re: change value 09-15-2012, 06:46 AM
Winon Re: change value 09-15-2012, 08:34 AM
HaHoBe Re: change value 09-15-2012, 09:05 AM
patel45 Re: change value 09-15-2012, 09:30 AM
Winon Re: change value 09-15-2012, 09:18 AM
Winon Re: change value 09-15-2012, 09:45 AM
  1. #1
    Forum Contributor
    Join Date
    02-07-2011
    Location
    Bhutan
    MS-Off Ver
    Excel 2007
    Posts
    244

    change value

    Hi Friends,

    I am stuck at problem, and was hoping if anybody could please help me out with a VBA code that will run with Column G.
    I have an excel sheet, in cell G2 I have Team A or Team B or Team C.
    Cell position G2 is deciding factor.If G2 is Team A then anything below it should be Team B, or if Team B then anything below it should be Team A.
    In this example file G2 value is Team A, but G3 is team B then automatically the corresponding value of C changes to "Retest on next sample".
    Then G4 is team B then automatically the corresponding value of C changes to "Retest on next sample".
    Then G7 is team C then automatically the corresponding value of C changes to "Retest on next sample".

    But if the cell is blank (that means no team) then the code will not change the cell value in Column C.

    I am attaching the example file for reference.
    Please help me friends,
    Thanks in advance,
    best regards,
    me
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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