+ Reply to Thread
Results 1 to 5 of 5

time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2011

  1. #1
    Registered User
    Join Date
    02-13-2020
    Location
    United States
    MS-Off Ver
    mac 2011
    Posts
    3

    time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2011

    I am sure there are similar post/threads on this but I was not able to find them. Please direct me that way as I do not want to restart a topic that has already been explain and resolved.

    I am attempting to create an excel document that my fire department can use to track and record all our daily activities, emergencies, training etc. I am familiar with the basics of excel but that is about it. I have created the foundation of the document but need help adding in the formulas and "advanced" actions.

    I am using Excel Mac 2011.

    I would like each cell in row a to be updated with the current time when row d is edited and then i would like to be able to double click a cell in row b to add the current time again. I think I attached the excel document. Let me know if I did not.

    Thank you in advance.
    Attached Files Attached Files

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    26,201

    Re: time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2

    Hi and welcome to the forum

    First of all you can't do this with a formula. You'll need a sheet change event macro to do this.

    Would you clarify exactly what you want to see. I understand you are saying that if you enter something in say D10 you want the current time in A10 & B10 - and presumably not C10 since this contains items from a drop down.

    Then in addition of you double click say B10 you want the current time to overwrit what is in B10.

    Is that correct?
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    02-13-2020
    Location
    United States
    MS-Off Ver
    mac 2011
    Posts
    3

    Re: time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2

    Yes, when I enter something into D column I would like the time stamp to be added only to the column A cell. As that would be the start time or out time and column B is the end times or in times for the vehicles if that makes sense but. I would like the column B cells to get the time stamp after a double click.

  4. #4
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Excel for Windows & Mac - all versions.
    Posts
    26,201

    Re: time stamp cell in A when cell in D is edited, again in B w/ double click. excel mac 2

    Use the following two sheet event macros

    Please Login or Register  to view this content.
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    02-13-2020
    Location
    United States
    MS-Off Ver
    mac 2011
    Posts
    3
    The problem I am having is I do not know how to navigate excel and where to go too, to enter the code if that makes sense.

    Thank you in advance
    Last edited by AliGW; 02-21-2020 at 08:01 AM. Reason: Please don't quote unnecessarily!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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