Changable Pricelist

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


Hi All,

I was wondering if Excel can do something like the following:

I am trying to design a price list for our computer store.

For example if we are selling 3 different packages, I would like to be
able to click on a drop down box and click on which package the
customer is looking at, and when I do this, listed should show all the
products in the system build to make up to the final sell price of that
particular build.

If a customer then wants to change to a 19" LCD monitor instead of a
17", we should be able to click a dropdown box under the header
Monitors, and click the 19" model, which should in turn change to total
price accordingly. Same should apply in they click no monitor; it
should then deduct any monitor pricing from the total build price.

Can Excel do this, and is it easily achievable?

Thanks

DazMAn


--
DazManPosted from http://www.pcreview.co.uk/ newsgroup access

.

Relevant Pages