+ Reply to Thread
Results 1 to 8 of 8

auto date cell when adjacent cell has data entered?

  1. #1
    Registered User
    Join Date
    10-31-2007
    Posts
    6

    auto date cell when adjacent cell has data entered?

    hi there - new here. i am putting together a worksheet in which i have a spreadsheet that id like to automate. when i enter, say a reservation number id like another cell on the same sheet to reflect the date that i entered that reservation number. i know its possible but not sure how to do it.

    thanks much in advance for this and for what i am sure to be future questions.

    kali

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    See link

    http://www.mcgimpsey.com/excel/timestamp.html

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    10-31-2007
    Posts
    6
    Quote Originally Posted by VBA Noob
    i think i love you - i'd make you cookies if i could - thank you. was not even sure of what i was doing as i did it but it worked. now on to the next....

    have a great day

  4. #4
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Your welcome.

    Thx for the feedback.

    VBA Noob

  5. #5
    Registered User
    Join Date
    10-31-2007
    Posts
    6

    oO(sigh)

    thank for your help! i think i will just end up doing it all manually. this morning and when i refresh to see the sorting everything gets jumbled up. its not auto dating anymore - when i refresh it does something to make it stop. the auto sorting isnt working for me either. anyway, i appreciate your help - thanks mucho!!

  6. #6
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    Sorry to hear that. Did you enable macro's ??

    If you need to do manually see link

    http://office.microsoft.com/en-us/ex...CH010005121033

    VBA Noob

  7. #7
    Registered User
    Join Date
    10-31-2007
    Posts
    6
    yes i enabled. ok i'll check out the link. thank you so much for your time!

  8. #8
    Registered User
    Join Date
    10-31-2007
    Posts
    6
    ok i turned off all macro security even though it was "not recommended" and now it seems to be working - at least the auto date is.

    now, onto the next sheet and prolly a few more headaches.

    you're the best thank you for your patience

+ 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