when cell has entry

[1newguy]

I want to make for -example- if A3 has a entry, A5 will auto fill the time it was entered- I tried the TIME() function, may not be useing it correctly though
thanx

[DCSwearingen]

I want to make for -example- if A3 has a entry, A5 will auto fill the time it was entered- I tried the TIME() function, may not be useing it correctly though
thanx

Place this in the worksheet module for the sheet you want this action to take place.

Please Login or Register  to view this content.

Go to Debra Dalgleish's web site http://www.contextures.com/tiptech.html and scroll down until you find Dynamic Ranges and click the link to get an explanation on how to create them. As you can see from tips page, she has many tips available.