Results 1 to 3 of 3

Thread: Need last table column to auto update

  1. #1

    Need last table column to auto update



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hello,

    I am fairly new to writing any kind of code. i have a simple table that has columns A, B, and C with constant data. Columns D:P are blank but have a list to choose from when the task is complete. in Column Q i have an If formula to determine if cells D:P are blank and if all are not blank it returns "Ready". I have code written in VBA that creates a time-stamp in Column R when data is entered, it works great if i manually add data to Q. My problem is that the formula doesn't change the contents of the cell and i would like it to automatically update my time-stamp when all of my tasks are complete. My thought was using an "If ElseIf Then" but i couldn't make it work for me. i have tried for 3 days to do this, i know there has to be a way. Attached is a sample of my workbook with the code for the time-stamp. Please help me as this is turning my hair even more gray than it already is. Thanks in advance!

    -John
    Attached Files Attached Files

  2. #2
    Magician NoS's Avatar
    Join Date
    Jan 2013
    Location
    British Columbia
    Posts
    751
    Articles
    0
    Excel Version
    Excel 2010 64bit
    This is a deceptive situation. The Change event is not fired by a cell containing a formula. What Excel displays may change but what is actually in the cell (ie: the formula) does not change.

    Similar question at a couple other sites here and here.

  3. #3
    Yes that is exactly what i wanted to say, but you put it much more eloquently! Thanks for the links to the other posts, i will see if i can make something work from those suggestions.

Posting Permissions

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