Changable Pricelist

[DazMan]

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 b
able to click on a drop down box and click on which package th
customer is looking at, and when I do this, listed should show all th
products in the system build to make up to the final sell price of tha
particular build.

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

Can Excel do this, and is it easily achievable?

Thanks

DazMA

 

[CLR]

Yes, it's "doable"..........no, it's not easy.
It's a project,..... and the developer would have to know all sorts of
things about your business to make it work, product lists, descriptions,
pricing, etc. If this is something you would undertake yourself, then start
in, and by all means, come back as needed with specific problems and we'll
be glad to assist.

Vaya con Dios,
Chuck, CABGx3

 

[RagDyer]

And a good place to start on this subject is to check out Debra Dalgleish's
web site at:

http://www.contextures.com/tiptech.html

And scroll down to the D's, and read all the pages on "Data Validation",
which is one approach of doing what you might be looking for, although maybe
not exactly.

If you would be willing to sacrifice some of the functionality that you
described, you could probably come close and do it yourself.
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Yes, it's "doable"..........no, it's not easy.
It's a project,..... and the developer would have to know all sorts of
things about your business to make it work, product lists, descriptions,
pricing, etc. If this is something you would undertake yourself, then start
in, and by all means, come back as needed with specific problems and we'll
be glad to assist.

Vaya con Dios,
Chuck, CABGx3