Results 1 to 6 of 6

If cell A1 already contains a value don't update timestamp in B1

Threaded View

  1. #1
    Registered User
    Join Date
    08-17-2008
    Location
    UK
    MS-Off Ver
    Office Professional 2003 & 2010
    Posts
    11

    Question If cell A1 already contains a value don't update timestamp in B1

    Hi all,

    I have a problem I can't get my head around so I'm hoping you can help please?

    I have a drop-down on each row in column A with a range of stages such as "Await Reply", "More Info Requested" etc.
    I want column B to add a timestamp with Value = Now() when the first status is chosen in A, but I want B to ignore any further status updates to A (in order to always show the very first time a record is touched).

    At present, the line of code I am using is
    If ActiveCell.Value >= 0 Then ActiveCell.Offset(O,1).Value = Now()
    however this populates column B the first time A is updated, but also every time the status changes thereafter...

    Can someone please provide the code I need to achieve this please?

    Many thanks,
    Steve
    Last edited by BEERCAN; 11-25-2011 at 01:26 PM.

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