this is my problem:


i got worksheets number from 1-30 (days of the month) and in each
worksheet

the formats are the same. The format look something like this:

unique ID vehicle no date in date out status


in date in,i want to have a formula that automatically insert the date
when i key

in a vehicle num . The date in will also be the same as the sheet no,
so can i use

a indirect formula to return the date?


--
cjjoo
------------------------------------------------------------------------
cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916
View this thread: http://www.excelforum.com/showthread...hreadid=476165