How can I use like a mail merge feature in excel to create a form
 

I have a "request" form set up in excel. I want to be able to make fields
that I can set and store options for and chose the option that I want each
time instead of having to type the data each and every time. For example:

Art Request To: ______________________________

In the blank, I want to be able to choose from the different locations that
we normally have our art sent to. The information would appear like this:

MaryAnne Smith
ABC Company

Is there a way to create like a "drop down" menu in a cell that allows for
choosing options?

Or perhaps there is a better way? PLEASE HELP!!! I do these things everyday
and need a better way to do them.

Use data validation. Check out following link for details:

http://www.contextures.com/xlDataVal01.html


"CindyW" wrote in message
...
I have a "request" form set up in excel. I want to be able to make fields
that I can set and store options for and chose the option that I want each
time instead of having to type the data each and every time. For example:

Art Request To: ______________________________

In the blank, I want to be able to choose from the different locations
that
we normally have our art sent to. The information would appear like this:

MaryAnne Smith
ABC Company

Is there a way to create like a "drop down" menu in a cell that allows for
choosing options?

Or perhaps there is a better way? PLEASE HELP!!! I do these things
everyday
and need a better way to do them.

Is there a way that if I choose 1 option in the first field that it will
automatically choose other options for me?

Such as:

Fruit: Cherries
Color: Red
co Yes
Vine/tree: vine

I want to be able to pick cherries and then possibly have the other options
filled in based on my 1st choice. Can this be done?

"Shatin" wrote:

Use data validation. Check out following link for details:

http://www.contextures.com/xlDataVal01.html


"CindyW" wrote in message
...
I have a "request" form set up in excel. I want to be able to make fields
that I can set and store options for and chose the option that I want each
time instead of having to type the data each and every time. For example:

Art Request To: ______________________________

In the blank, I want to be able to choose from the different locations
that
we normally have our art sent to. The information would appear like this:

MaryAnne Smith
ABC Company

Is there a way to create like a "drop down" menu in a cell that allows for
choosing options?

Or perhaps there is a better way? PLEASE HELP!!! I do these things
everyday
and need a better way to do them.

Yes, by creating a lookup table.

http://www.contextures.com/xlFunctions02.html

"CindyW" wrote in message
...
Is there a way that if I choose 1 option in the first field that it will
automatically choose other options for me?

Such as:

Fruit: Cherries
Color: Red
co Yes
Vine/tree: vine

I want to be able to pick cherries and then possibly have the other
options
filled in based on my 1st choice. Can this be done?

"Shatin" wrote:

Use data validation. Check out following link for details:

http://www.contextures.com/xlDataVal01.html


"CindyW" wrote in message
...
I have a "request" form set up in excel. I want to be able to make
fields
that I can set and store options for and chose the option that I want
each
time instead of having to type the data each and every time. For
example:

Art Request To: ______________________________

In the blank, I want to be able to choose from the different locations
that
we normally have our art sent to. The information would appear like
this:

MaryAnne Smith
ABC Company

Is there a way to create like a "drop down" menu in a cell that allows
for
choosing options?

Or perhaps there is a better way? PLEASE HELP!!! I do these things
everyday
and need a better way to do them.