On Jan 5, 4:21*pm, Rick wrote:
Hi,

I did my best to search for an answer but come up empty.

Here's what I'm trying to do....
I have a spreadsheet with worksheets/tabs for Monday through Friday and one
for weekly totals. I would like to automatically insert a date into the
worksheet on the day that the sheet is populated. The worksheet will not be
edited afterwards so I'm good with current date.

I used the =NOW() for an automatic date(and time) that updates when the
sheet formulas are recalculated BUT it also updates the other worksheets.

Is there a way to keep the dates independently updated on each individual
worksheet?

Thanks!

You could put some VB code.

Sub DateIt()
ActiveSheet.Range("C2") = Date
End Sub

Load this into a module by clicking Alt + F11. Go to the worksheet
name and select insert module. In the module insert this code. Go
back to the sheet and Add a button to each day of the week and use
this as the macro for the button. Change C2 in the code above to the
cell you want to change.

This code is nto tested.

Jay