dates

Originally Posted by Radonsheep

is there a way to have the current date auto fill to a cell if enter a value on the same row..? instead of having to type in the date then the product or value?

Hi,

If you use a formula that tests the A column and inserts a date in the B column, then that date will update with each passing day.

If you want to detect and retain the date on which an entry was made in the A column, then, on the worksheet tab, rightmouse and 'View Code' and copy the following code into there.

Please Login or Register  to view this content.

hth
---