LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
CindyW
 
Posts: n/a
Default 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.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link excel and word in mail merge without losing your data source? angie Excel Discussion (Misc queries) 5 July 1st 05 06:29 PM
How can I get excel to mail merge zip codes plus 4 correctly? Kathy at Sauder Feeds Excel Worksheet Functions 1 June 30th 05 11:21 AM
Different graphic for each record in mail merge document Alex St-Pierre Charts and Charting in Excel 1 May 4th 05 07:26 PM
Mail merge (Word97) only importing 1st 85 rows of info from Excel Kali Carringer Excel Discussion (Misc queries) 3 March 26th 05 05:33 AM
Mail merge to a chart Alex St-Pierre Charts and Charting in Excel 1 November 28th 04 05:05 PM


All times are GMT +1. The time now is 02:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"