Good Afternoon -
I wasn't sure how to describe this in the title. Using Office 2010 on Windows XP
I'm creating a quote template for our organization. My one obstacle now is that we have a catagory of items that we regularly choose between 2 totally different setups based on the facility.
I'm trying to come up with a way that a user can toggle or otherwise choose which list of products to use in the quote, without adding in the other items at all.
I would really prefer to find a way to do this without scripting if it's possible simply because I've been able to totally avoid it to this point and without using scripts this becomes vastly more portable (IE - I can port this out to the web and use it on phones/tablets/etc). I have a feeling this isn't possible without scripts but I can dream, right?
In the attached example, I might have a red phone bundle and a bluephone bundle. They have different amounts of items that go into them with different quantities and breakdowns, etc.
I need to be able to have the amount in cells D3 through G3 accurately reflect the total costs for whichever bundle the users chooses.
Hope this makes sense. Thanks for any suggestions anyone has - even if it is to tell me this isn't possible as I'm picturing it.
I wasn't sure how to describe this in the title. Using Office 2010 on Windows XP
I'm creating a quote template for our organization. My one obstacle now is that we have a catagory of items that we regularly choose between 2 totally different setups based on the facility.
I'm trying to come up with a way that a user can toggle or otherwise choose which list of products to use in the quote, without adding in the other items at all.
I would really prefer to find a way to do this without scripting if it's possible simply because I've been able to totally avoid it to this point and without using scripts this becomes vastly more portable (IE - I can port this out to the web and use it on phones/tablets/etc). I have a feeling this isn't possible without scripts but I can dream, right?
In the attached example, I might have a red phone bundle and a bluephone bundle. They have different amounts of items that go into them with different quantities and breakdowns, etc.
I need to be able to have the amount in cells D3 through G3 accurately reflect the total costs for whichever bundle the users chooses.
Hope this makes sense. Thanks for any suggestions anyone has - even if it is to tell me this isn't possible as I'm picturing it.
Book2 | |||||||||
---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | |||
1 | ExtendedPrice | ||||||||
2 | Item# | Description | Qty | ListEach | OurPrice | Capital | Operating | ||
3 | PhoneStuff | $0.00 | $0.00 | $0.00 | $0.00 | ||||
4 | EachPhoneSetConsistsOf: | ||||||||
5 | ChooseRedorBlue | ||||||||
6 | RedBundle | ||||||||
7 | 12 | RedItem1 | $7,277.40 | $13,995.00 | $0.00 | ||||
8 | 13 | RedItem2 | $520.00 | $1,000.00 | $0.00 | ||||
9 | 14 | RedItem3 | $260.00 | $500.00 | $0.00 | ||||
10 | 15 | RedItem4 | $247.00 | $475.00 | $0.00 | ||||
11 | 16 | RedItem5 | $1,040.00 | $2,000.00 | $0.00 | ||||
12 | 17 | RedItem6 | $286.00 | $550.00 | $0.00 | ||||
13 | 18 | RedItem7 | $457.60 | $880.00 | $0.00 | ||||
14 | BlueBundle | ||||||||
15 | 23 | BlueItem1 | $4,495.00 | $2,472.25 | $0.00 | ||||
16 | 24 | BlueItem2 | $3,200.00 | $1,760.00 | $0.00 | ||||
17 | 25 | BlueItem3 | $457.60 | $251.68 | $0.00 | ||||
18 | 26 | BlueItem4 | $8,990.00 | $4,944.50 | $0.00 | ||||
19 | 27 | BlueItem5 | $2,200.00 | $1,210.00 | $0.00 | ||||
Sheet1 |