Updating a status
Results 1 to 2 of 2

Thread: Updating a status
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Dec 2016
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Updating a status

    Looking for help with the below....


    Basically,

    I want to track the status of an item.

    If i am to enter a date lets say in column C which is titled " Item setup date" i would like the status in column B to automatically change of i enter that date.
    But again, if i enter data further down the line in another column. Column E "Sales order received", i want the status to update again to reflect the new update.

    Whats the best approach, IF statements?

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,050
    Post Thanks / Like
    Mentioned
    19 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Updating a status

    A cell can contain a formula or a value, not both.
    Formulas cannot change other cells, they can be the result of other cells though.

    So if you type a status into column B and later want it to be the result of you entering something into column C, you cant do that witha formula, you need VBA for that.

    For the value in column B to "change" as you've said, it's not clear how the previous value got into B in the first place, I presume by you entering it, therefore you would need VBA as described above.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •