+ Reply to Thread
Results 1 to 7 of 7

automatically change the value in one cell based on other

Hybrid View

  1. #1
    Registered User
    Join Date
    09-11-2019
    Location
    india
    MS-Off Ver
    2016
    Posts
    78

    automatically change the value in one cell based on other

    Hi All,

    Hope you all are safe and doing well.

    I need a help with the excel with the below

    I need 2 things;
    1st:
    I have a sheet with data validation controls. Please see the attached excel sample sheet.
    What I need is when a value is selected from the dropdown list in Column B, in column A it should come as "Ready for Review".
    I have tried a formula (check A7), but not helping me .

    2nd:
    When user select the dropdown list in column B and the status gets updated to "Ready for review" in column A, I need an audit trial in column C, Like the date, time and user name. I am not sure is this is possible.

    Thanks in advance.
    EDIT1: added xlsm sheet for Sintek to review.

    NOTE: The code works fine. I was trying to run the code so was having problem. you do not have do anything. you just put it in Sheet1 and save it. I will work seamlessly.
    Attached Files Attached Files
    Last edited by sudhansu121; 05-06-2021 at 08:54 AM.

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,331

    Re: automatically change the value in one cell based on other

    Put code in Sheet Module

    Private Sub Worksheet_Change(ByVal Target As Range)
    If Not Intersect(Target, Range("B:B")) Is Nothing Then
        Application.EnableEvents = False
        With Target
            .Offset(, -1) = "Ready For Review"
            .Offset(, 1) = Environ("UserName") & " | " & Now()
        End With
        Application.EnableEvents = True
    End If
    End Sub
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    09-11-2019
    Location
    india
    MS-Off Ver
    2016
    Posts
    78

    Re: automatically change the value in one cell based on other

    Hi Sintek,
    I tried the code, but nothing is coming . Not sure whats happening.

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,331

    Re: automatically change the value in one cell based on other

    Is the code in the Sheet Module...
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-11-2019
    Location
    india
    MS-Off Ver
    2016
    Posts
    78

    Re: automatically change the value in one cell based on other

    Thank you so much Sintek You are amazing.

    I just misunderstood your text target module instead of sheet1, I was putting it in "Module" so was not working

    Cheers.....

  6. #6
    Registered User
    Join Date
    09-11-2019
    Location
    india
    MS-Off Ver
    2016
    Posts
    78

    Re: automatically change the value in one cell based on other

    Hi Sintek,
    I am so sorry , I am again facing the same issue. Please see the attached sheet. its not happening. Not sure how to add attachment in this chat. I will add the .XLSM sheet in the mail post.

  7. #7
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,331

    Re: automatically change the value in one cell based on other

    So all is sorted...? Thanks for rep +

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Automatically Change Row Color Based on Cell Input
    By socialconstruct in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-16-2019, 06:39 AM
  2. Automatically change cell based on date
    By scooterboygnu1 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-27-2017, 07:45 AM
  3. I need cell to automatically change color based on date in different cell
    By acooley in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 08-27-2013, 04:55 PM
  4. automatically change cell value based on the value in other sheet.
    By star.dust9212 in forum Excel - New Users/Basics
    Replies: 4
    Last Post: 11-15-2011, 06:21 AM
  5. Automatically change text in cell based upon a rule
    By Beanymonster in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 10-16-2009, 09:28 AM
  6. Having Cell Color Change Automatically Based on Value
    By jamesfedwards in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-21-2006, 10:47 AM
  7. [SOLVED] Font to change color automatically based on value in cell.
    By mtwelsh72 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-23-2005, 03:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1