Ashish
thanks heaps, worked like a charm

Satisfied Mike Tommo

"Ashish" wrote:

Hi,

Answer is

=IF(COUNTA(Sheet2!C8:I59)<0,NOW(),"")

Paste this formula in column D2

Thanks
Ashish

Tommo wrote:
I am trying to get cell D2 on sheet 1 to automatically add date and time when
a number is entered in any cell within a range a cells (C8:I59) on sheet 2.
I am using Excel 2002

Can anyone please help
Frustrated Mike