Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
TerriF
 
Posts: n/a
Default need to populate several cells based on drop down menu selection

I have created a validation drop down menu for specific options and I am now
trying to automatically populate different cells in this worksheet based on
the option chosen.
  #2   Report Post  
Debra Dalgleish
 
Posts: n/a
Default

You can use a VLookup formula to return the matching values. There's an
example he

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

TerriF wrote:
I have created a validation drop down menu for specific options and I am now
trying to automatically populate different cells in this worksheet based on
the option chosen.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Reply
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
Is it possible to change colors of cells based on value in cell (. LC Excel Worksheet Functions 3 January 14th 05 06:27 AM
How do I select cells and make the info populate into a form? jompeters Excel Worksheet Functions 0 January 7th 05 10:43 PM
how do you format a row of cells based upon a value in another ce. hazenb1 Excel Discussion (Misc queries) 1 December 9th 04 05:22 AM
conditional formating - Highlighting text cells based on sales res ANDREW_B Excel Discussion (Misc queries) 7 December 2nd 04 05:27 PM
how do you create drop down menus for individual cells in excel? Frosty1 Excel Worksheet Functions 2 November 16th 04 12:02 AM


All times are GMT +1. The time now is 03:20 PM.

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

About Us

"It's about Microsoft Excel"