No update of dates

C

chileno74

I have a worksheet, which is a log of clients I see everyday and it
goes for 2 weeks at a time. How can I use one of the functions, ie:
today(), and have the worksheet pick up the correct date everyday, but
without updating the previous dates in that worksheet?

Thank you in advance.

Hernan.
 
B

bigwheel

[email protected] said:
I have a worksheet, which is a log of clients I see everyday and it
goes for 2 weeks at a time. How can I use one of the functions, ie:
today(), and have the worksheet pick up the correct date everyday, but
without updating the previous dates in that worksheet?

Thank you in advance.

Hernan.
Click to expand...
Try entering this as the code for a workbook page

Private Sub worksheet_activate()
Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveCell = Date
End Sub

Each time the sheet is opened, the date is put into the next empty cell
 
C

chileno74

Thank you Bigwheel for replying. However, I don't understand where is
it that I have to enter this code.

Could you please explain it.

Thanks again.

Hernan
 
B

bigwheel

[email protected] said:
Thank you Bigwheel for replying. However, I don't understand where is
it that I have to enter this code.

Could you please explain it.

Thanks again.

Hernan
Click to expand...
OK. Click Tools>Macro>Visual Basic Editor
When it opens, you should see in the left hand column, the name of your open
workbook. Double click the sheet name and paste the code into the empty
window that appears on the right. Then, each time you open that worksheet,
it should enter the date in the next empty cell in column A
 
C

chileno74

Hi Bigwheel,

I tried this but it didn't work.

I even formatted column A as DATE, and nothing.

Thank you for helping me anyway.

Hernan.
 
H

Hernan

Now is doing it! :) Thanks.

Question... What do I have to add in order for the "cursor" to move to the
right once the date is placed?

Where can I read about all this stuff? :)

Hernan
 
B

bigwheel

Hernan said:
Now is doing it! :) Thanks.

Question... What do I have to add in order for the "cursor" to move to the
right once the date is placed?
Activecell.Offset(0,1).Select

Where can I read about all this stuff? :)
Click to expand...

There are many Excel books available
 
Top