Fantastic... works great. I did modify the command to just read =Input!B1
because I didn't quite understand how to work the formula you gave me.

For example: =if(input!b1="","",input!b1). If I am only transfering
information, Why use an "if" statement. When I put this in the form cell,
and put a sample information 1234 on cell b1 of the input page, I got a REF#
error.

I am assuming that I am supposed to have more information in the
=if(input!b1="","",input!b1) string... perhaps in the quotes? I'm just not
familiar enough with the formula.

Heres how I am translating it in my mind... If Cell B1 on the sheet titled
"Input" equals... at this point I'm unsure what the quotes are to
respresent... then... again make the cell value... again not sure what the
quotes represent...if not, then input the information in Cell B1 of the
"Input" sheet.

I'm also a bit embarrassed to admit the I am a little confused about the
<bg symbol you placed after the suggestion to name the input page Input <bg

Like I said the direct input formula works fine for what I'm doing right
now, I'm just afraid that I will run into a situation where your full formula
will be necessary.

Thanks so much for you assistance.

Mr. Ziggy

"Dave Peterson" wrote:

You could create an Input sheet. I'd name it Input <bg.

Then in column A, put a nice description. In column B, put your entry:

A B
FirstName Ziggy
LastName Stardust
Salutation Mr (or Ms.)
....
etc

Then on your Forms sheet, you'd use a formula that points back to that input
sheet.

=if(input!b1="","",input!b1)
(to grab the first name)

You could even protect the forms sheet so that you can't overwrite the formulas:
tools|protection|protect sheet




Mr. Ziggy wrote:

I have a specific Application Form that I must fill out by hand at each
interview. I have created the form in Excel to allow me to type the info
into the appropriate fields. This however labor intensive and it is easy to
make a mistake that may change a different field.

Can I create separate listing or database (similar to the mail merge
concept) that will just drop the info into the proper cells on the form with
out me touching the form itself?

--

Dave Peterson