Solved

excel 13 multiple selections

Posted on 2015-02-21
9
38 Views
Last Modified: 2015-03-24
I'm working on a bid sheet that has multiple price list associated with it. I've set up separate vlookup drop down lists but , more than one possibility exists within the list. Can I populate a dropdown list that allows a user to select more than one item or do I need a different approach? I have attached a sample of my bid sheet and a data sheet that has more than one selection that could apply (in fact in this case 3 could apply). I'm afraid I have taken an incorrect approach altogether?
Test-Multiple-dropdown.xlsx
0
Comment
Question by:alohamelinda
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 3
9 Comments
 
LVL 12

Expert Comment

by:FarWest
ID: 40623893
could  you provide more clarification about the request,
do you mean you need to select 3 different lines to be shown in the Bid sheet from price list sheet?
0
 

Author Comment

by:alohamelinda
ID: 40624069
Yes I'm sorry, I would like to return a possibility of more than one line or price to the bid sheet from the price list. Short story is more than one price apply and it looks silly having multiple exact drop downs. Hope you can help.
0
 
LVL 12

Expert Comment

by:FarWest
ID: 40624080
Could you please show me a sample of the complete  bed sheet contents. When it has 3 possibilities
You mean you don't need to repeate drop down options to second and third row and you need filtered drop down?
0
Building an interactive eFuture classroom

Watch and learn how ATEN provided a total control system solution including seamless switching matrix switch, HDBaseT extenders, PDU, lighting control to build an interactive eFuture classroom.

 

Author Comment

by:alohamelinda
ID: 40624401
That's it exactly. Here's a sample of my decking price sheet. The drains are applicable in just about every circumstance whether it's a paver deck, concrete or say brick. I guess I could create a separate data sheet for the drains, step risers,  etc... How does the filtered dropdown work in this case? Attached is a sample bid sheet for my deck prices.
Deck-Workbook-test.xlsx
0
 
LVL 12

Expert Comment

by:FarWest
ID: 40624422
it is better to have category column in your bid sheet to apply filtered list , so when user select the category options in the items will be changed, as I can see you have limited item list, so you can have complete option sheet to all applicable options for each drain  you just select the option and all relevant items will be shown and then you can put 0 or not provided in quantity cell for not included items, this way will help in not forgetting any item :)
let me know if you like to apply category solution, or options based solution
0
 

Author Comment

by:alohamelinda
ID: 40624468
I'm intrigued. Can you show me a sample of how the category solution might work. Here's an example, I choose:

STD Deck 400 sq ft concrete $0
6" step risers QTY= 20 l. ft.
Paver/Flagstone Accent Bands QTY  = 40 l.ft.
Deco Drain QTY = 40'

How would that look? Sorry my knowledge is so basic.
0
 
LVL 12

Accepted Solution

by:
FarWest earned 500 total points
ID: 40627691
sorry for delay
check this as a Category Implementation Sample
Deck-Workbook-test-1-v2.xlsx
0
 
LVL 47

Expert Comment

by:Martin Liss
ID: 40684222
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
This article describes how you can use Custom Document Properties to store settings and other information in your workbook so that they will be available the next time you open the workbook.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

724 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question