Thank you for sharing this cleverly designed worksheet.
Have been playing with it for a couple of days now and am integrating it into my existing tracking sheet (where bodyweight and personal finances are among the other variables being tracked).
I have made a small modification to enable faster date- and time entry with keyboard shortcuts. Save the spreadsheet as a macro-enabled workbook, then open the VBA editor with alt+f11. Hit ‘insert’; ‘module’; paste the code below and save. You can now enter the current date using ctrl+d and the current time with ctrl+t.
Thank you for sharing this cleverly designed worksheet.
Have been playing with it for a couple of days now and am integrating it into my existing tracking sheet (where bodyweight and personal finances are among the other variables being tracked).
I have made a small modification to enable faster date- and time entry with keyboard shortcuts. Save the spreadsheet as a macro-enabled workbook, then open the VBA editor with alt+f11. Hit ‘insert’; ‘module’; paste the code below and save. You can now enter the current date using ctrl+d and the current time with ctrl+t.
Sub ins_date() ′ ′ insdate Macro ′ ′ Keyboard Shortcut: Ctrl+d ′ ActiveCell.FormulaR1C1 = “=TODAY()” ActiveCell.Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks :=False, Transpose:=False Application.CutCopyMode = False
End Sub Sub ins_time() ′ ′ ins_time Macro ′ ′ Keyboard Shortcut: Ctrl+t ′ ActiveCell.Value = Time
End Sub