Hi everyone, I have set up an Excel spreadsheet only 15 columns but that is all I need. At present I have to make 3 entries, the date in A, a figure in B and a figure in D then Excel does the rest, great stuff.
What I am tring to do now is set it up so that I only have to make an entry in B or D and the date sets in A automatically in the format xx.xx.xx I do not need the time.
When I move down to the next line I need the preceding line to remain at the same date but the new line to have the current date.
Looking into this it appears to be possible and I have experimented with =now() but I need some more guidance yet again.
The problem with using Today() or Now() is that these values will update automatically when the date or time changes. You need a little bit of code to do what you want:
Private Sub Worksheet_Change(ByVal r As Range) If r.Count > 1 Then Exit Sub If r.Column = 2 Or r.Column = 4 Then Cells(r.Row, 1).Value = Date End Sub
To use this, right click the sheet tab and select View Code. Then copy the code above and paste it into the window that should have appeared. Close that window and try entering a value in column B or D.