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