I have forms that i fill out many times daily. Its basic setup is as below:

Date WAT# IAT# SN#
10/3/07 7:45 AM 40000106 0001758365 8F06481

I have a seperate sheet in my notebook that automatically populates the
serial number and IAT# when I enter the WAT#. what i am looking for is a way
to reduce the time spent editing, copying, and pasting. First problem is the
IAT# is always listed as a 7 digit number in the database, but in reality it
is 10 digits with me having to maually add the "000" before the 7 digit
number. Is there a way to do this? Second is the date and time. Is there a
way to enter the formula =now() and then have it automatically cut and paste
itself after each entry so I dont have to worry about the time stamp changing
after each close/reopen of my notebook? Finally, when I enter the WAT# I have
a vlookup that populates the other 2 serial number fields. But if I enter
anything else I need the other 2 fields to automatically populate the word
"parcel". Is there a way to manipulate the vlookup formula to accomplish
this?

Thanks for your help. I know this is quite a laundry list.



--
Clark