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
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