Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 18th 05, 10:04 PM
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  
Old May 18th 05, 10:27 PM
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 05:27 AM
How do I select cells and make the info populate into a form? jompeters Excel Worksheet Functions 0 January 7th 05 09: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 04:22 AM
conditional formating - Highlighting text cells based on sales res ANDREW_B Excel Discussion (Misc queries) 7 December 2nd 04 04:27 PM
how do you create drop down menus for individual cells in excel? Frosty1 Excel Worksheet Functions 2 November 15th 04 11:02 PM


All times are GMT +1. The time now is 12:47 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017