Excel Question

[far]

Is it possible to 'date stamp' notes that you put in an excel spreadsheet instead of typing the date everytime?

 

TIA

FAR

[AlexJames]

yes... usually its insert date... the problem is, that every time you open the sheet, the date will get updated to the 'actual' date.

 

If its for printing purposes it would be fine.

[AlexJames]

oooh wait, im wrong... insert date is in Word... there is a real simple formula to do this... give me two ticks...

[AlexJames]

=TODAY() Current date (varies)

=NOW() Current date and time (varies)

[AlanM]

=TODAY() Current date (varies)

=NOW() Current date and time (varies)

 

This will still change each time you open the sheet though

[Jas]

Just write a little macro and attach a short cut key to it.

 

something like this will add a time and initial stamp to any cell when you press ctrl t.

 

Sub Macro2()

 

' Keyboard Shortcut: Ctrl+t

'

Dim timestamp As String

 

MyInitials = "JSJ"

timestamp = Now()

 

 

ActiveCell.FormulaR1C1 = ActiveCell.FormulaR1C1 & " " & timestamp & " - " & MyInitials

 

End Sub

[far]

thanks guys, erm I think I wasnt clear in my initial description - I dont want to update the entire date of the spreadsheet, I have a 'notes' column and when I go into the cells under this column I would like to add a date stamp as to when the note was added.

 

Jas, I think your solution would work - I will have a go at writing the macro, managed to find a tut on google

[far]

ok using instructions below doesnt seem to work, any ideas on how I go about adding a Macro to the spreadsheet (please treat my knowledge of excel as VERY basic)

[Jas]

easiest way is to do the follwing.

 

tools>Macro>record new macro.

 

Name it appropriately, and stick in a letter of your choice in the shortcut key box.

click ok.

 

type some random stuff in the spreadsheet "iwg iugdeug" will do..

then go to

tools>Macro>stop recording.

then

tools>Macro>macros...

select the macro you just recorded and press edit.

code screen will open and you will see some code relating to your random typing (eg "iwg iugdeug" )

 

paste in the code in my first reply, save and close the VB screen.

 

when you ctrl + whatever key you specified now in your workbook it should date stamp it.

 

any probs give me a shout.

[far]

Big thanks to Jas for sorting this - you da man

[Jas]

no probs bud. any time.