Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 23
Default insert drop-down list without existing cell info

I am wanting to create a list of "bidding instructions" for our
sub-contractors, of course different homes will have different instructions
associated with them

for example what type of roofing

is there a place I can just type in standard instructions for say ashpalt
shingles, and then concrete tiles then when the time comes just select which
one I would want to insert on this set of instructions

Ideally I would like to see a pull-down menu that says "ashpalt shingles"
and "concrete tiles" select which one I want and excel will insert the more
lenghty set of instruction such as, say I choose "asphalt shingles" it will
insert " bid per plans using ........asphalt shingles.......more info....etc"
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,979
Default insert drop-down list without existing cell info

YOu can create a dropdown list by using data validation. There are
instructions in Excel's help, and he

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

To fill in related information after an item is selected, you can use a
VLookup formula. There's an order form example shown he

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

dustin wrote:
I am wanting to create a list of "bidding instructions" for our
sub-contractors, of course different homes will have different instructions
associated with them

for example what type of roofing

is there a place I can just type in standard instructions for say ashpalt
shingles, and then concrete tiles then when the time comes just select which
one I would want to insert on this set of instructions

Ideally I would like to see a pull-down menu that says "ashpalt shingles"
and "concrete tiles" select which one I want and excel will insert the more
lenghty set of instruction such as, say I choose "asphalt shingles" it will
insert " bid per plans using ........asphalt shingles.......more info....etc"



--
Debra Dalgleish
Contextures
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
How do i add a new entry to an existing drop-down list in Excel? ABD Excel Worksheet Functions 2 May 30th 07 04:46 PM
Adding items on an existing drop-down list Kumiko17 Excel Discussion (Misc queries) 2 November 14th 06 03:19 PM
Limit drop down list and linking to other info Intuit Excel Worksheet Functions 13 February 2nd 06 09:48 PM
insert a drop down list if a certain cell value is true kd Excel Worksheet Functions 6 January 25th 06 06:34 AM
How do I insert a drop down list in a cell using Phil Excel Worksheet Functions 2 May 8th 05 08:17 PM


All times are GMT +1. The time now is 03:33 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"