+ Reply to Thread
Results 1 to 4 of 4

Timestamp

  1. #1
    Registered User
    Join Date
    11-29-2007
    Posts
    10

    Timestamp

    Hey guys,

    I have been working on this macro for a little while now, but need some help refining it. Basically, this is what I would like:

    Column B to be marked with the current date/time whenever any information is entered in Columns C through J. However, I do not want this to update every time. I only want it to be marked whenever the first information is entered.

    Also, I only want there to be a timestamp present if there is data in Columns C through J. If I delete the information in Columns C through J, I would like the timestamp to be removed.

    See below for my current macro:

    Please Login or Register  to view this content.
    Any ideas?

    Thanks,
    Chris
    Last edited by ctasich; 06-16-2010 at 11:23 AM.

  2. #2
    Forum Expert Domski's Avatar
    Join Date
    12-14-2009
    Location
    A galaxy far, far away
    MS-Off Ver
    Darth Office 2010
    Posts
    3,950

    Re: Timestamp

    Please use code tags when posting code, see the forum rules.

    See if this does what you want:

    Please Login or Register  to view this content.

    Dom
    "May the fleas of a thousand camels infest the crotch of the person who screws up your day and may their arms be too short to scratch..."

    Use code tags when posting your VBA code: [code] Your code here [/code]

    Remember, saying thanks only takes a second or two. Click the little star to give some Rep if you think an answer deserves it.

  3. #3
    Registered User
    Join Date
    11-29-2007
    Posts
    10

    Re: Timestamp

    Sorry about that!...this works beautifully! Thank you!

    Chris

  4. #4
    Registered User
    Join Date
    06-02-2010
    Location
    Grand Rapids, Michigan
    MS-Off Ver
    Excel 2003
    Posts
    64

    Re: Timestamp

    You can also use a formula with a circuler refrence to do this.
    It would be (Starting in B1 put this formula and then just copy and paste it to the rest of B)
    =IF(OR(C1<>"",D1<>"",E1<>"",F1<>"",G1<>"",H1<>"",I1<>"",J1<>""),IF(B1="",NOW(),B1),"")

+ Reply to Thread

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