+ Reply to Thread
Results 1 to 4 of 4

Auto Static date and time when A column is >1

  1. #1
    Registered User
    Join Date
    03-16-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Auto Static date and time when A column is >1

    I am trying to make a blood glucose tracker. I would like it when the blood glucose is entered into column A, that moment of date and time automatically show in column B and C. The way I have it, it works. But when the next BG level is entered, it resets all previous dates and times.

    Thank you for any help.

    Bobby S.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Auto Static date and time when A column is >1

    BG Tracker X.xlsm

    Hi Bobby,

    The only way you can achieve this is with a VBA macro.

    I have added a macro to the Daily Entry worksheet. This should cause your workbook to behave as you want.

    Regards

    David


    When you reply please make it clear WHO you are responding to by mentioning their name.

    If this has been of assistance, please advise. A little thanks goes a long way.
    - Please click on the *Add Reputation button at the bottom of helpful responses.

    Please mark your thread as SOLVED:
    - Click Thread Tools above your first post, select "Mark your thread as Solved".

  3. #3
    Forum Expert
    Join Date
    11-26-2013
    Location
    Colac, Victoria, Australia
    MS-Off Ver
    Excel 2016
    Posts
    1,309

    Re: Auto Static date and time when A column is >1

    OOPS! Double Post

  4. #4
    Registered User
    Join Date
    03-16-2014
    Location
    USA
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Auto Static date and time when A column is >1

    Thank you David. I guess I need to stretch out of the spreadsheet commands and formulas and learn VBA now.

    Again, Thank you.
    Bobby

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Auto current Time In date in column a when words selected in column b
    By renceus in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 11-25-2013, 01:47 AM
  2. Vba to subtract current date from date in column G and put static diff in column H
    By jtyoder in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-31-2013, 02:55 PM
  3. anyway to make auto fill time value static?
    By Tezzz in forum Excel General
    Replies: 12
    Last Post: 11-28-2010, 05:42 AM
  4. Auto Static Date in Excel
    By lwk523 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-24-2010, 01:37 PM
  5. Extract data from filename and auto-set static date
    By Peter Visser in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-19-2010, 05:31 AM

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