Time and date stamp on a worksheet

[christal]

Can anyone tell me if you can put an automatic time and date stamp on a WORKSHEET only (let's say in a cell on that worksheet). I can't tell weather a particular sheet has been updated, only the file... and then I have to go into properties to find out.

Any ideas?

Thanks
Christal

Thanks!

 

[neomod]

This is totaly not related to the question but it just bugged me.

This is to you Tom,

Personnaly, I would have stopped after the "Thanks Buddy!" and told this guy to
"F Off!"

To have the nerve to someone like that and then proceed to TELL them try and find you another solution is just ridiculous!

Tom, I would not waste my time with someone that does not appreciate the help or at least the attempt to help.

 

[kinkyparamour]

Why would you want to be rude to someone who is asking for help? Not everyone understands the tearms used by the people on this or any other message board. Tom is always very helpful to the people in need of answers. Maybe you need to rethink your answer and offer help instead of rudeness.......


Denny

 

[kinkyparamour]

A possible answer could be a date stamp placed in a cell when a new person adds to your worksheet, maybe next to there name.

=if(isblank(a2),"",if(b2="",now(),b2))

Denny

 

[Legacy 98055]

I must be missing something here...?

 

[Brian from Maui]

On 2002-04-11 00:51, TsTom wrote:
I must be missing something here...?

Tom,

I think he's angry at christal

 

[christal]

Sorry to have offended you "neomod". But it was not my intention to be ungrateful of the information received from TsTom.

I was just letting him know I appreciated his information, and wanted to let him know that this particular resolution would not work in my situation (FYI). Simply asking him another way of resolving the problem happens throughout this bulletin board. I am relatively new to Excel, and I thought others may learn from my circumstance.

This is a "Great" web site to come to for people of ALL experience levels!

Cheers to all the contributors!