General discussion


Excel Spreadsheet Functions

By kenjensen24 ·
I want my spread sheet to get all the priceing off of one data source. I.E.

Size Tier
0 $0.00 $0.00 $0.00
12 $14.00 $12.00 $10.00
18 $16.00 $14.00 $12.00

I want to be able to select one of the tiers out of a combo box and have the entire page refer to that particular tier for pricing. Then i want to have another combo box to select the size and in turn put the corresponding cost into another cell. I am not sure if I am explaining what i want well enough. But if you get it and have a solution please, please email me or answer this.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by cbergmark In reply to Excel Spreadsheet Functio ...

How large is your data list? If it as small as your sample - how about re-arranging the data to
Tier Size price
a 0 0.00
b 0 0.00
a 12 14.00
b 12 12.00
c 12 10.00 (etc.)

Then use AutoFilter to limit tier and size? Not as techy as using combo boxes and forms, but just as effective if your data is small enough.

Related Discussions

Related Forums