Re: Drop Down List and Validation for 3 different amounts

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Debra,
I'm so sorry for still being stuck here. I went to the link and followed the
examples, but I'm still kind of confused as to how to apply this to my
specific task. If it's not too much to ask, I would like to restate what i
need to do with a short example of how the data must flow. In the example
below I only mention 3 procedures/items but there will be more than 30, and
need room to add more in the future, if possible. Here goes:

Let's say the 1st column needs a drop-down list with 3 Procedures: Back
Adjustment, Massage, Nutrition Book
The 2nd column needs a drop-down list for the Pricing Types: Regular,
Medicare, Cash
The 3rd column will then automatically fill in the correct pricing according
to the "Procedure and Pricing Type"
(This is because the price is different depending on which of the 3 is
chosen: Regular, Medicare, Cash).

For example purposes, let's say these are the prices:
Regular Medicare Cash
Back Adjustment $80 $40 $60
Massage $60 $20 $40
Nutrition Book $30 $15 $20

The 4th column will be Quantity, and the 5th Total Price (These are just
basic calculations: Price x QTY=TOTAL) This ofcourse is not the hard part for
me, LOL.
--
In God''s Harmony


"Debra Dalgleish" wrote:

There are instructions for dependent data validation here:

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

Roddy wrote:
Take a look where? I don't see a link or reference in your response.


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com


.

Relevant Pages

  • Re: Drop Down List and Validation for 3 different amounts
    ... The 2nd column needs a drop-down list for the Pricing Types: Regular, ... Regular Medicare Cash ... The 4th column will be Quantity, and the 5th Total Price (These are ...
    (microsoft.public.excel.misc)
  • Re: Gas station economics lesson
    ... Drove past a Shell offering Regular ... > The unit price ... When premium unleaded became available in Toronto, back in the '80s, ... > That they could keep the station open, pay the power bill and pay the ...
    (rec.autos.driving)
  • Re: Gas station economics lesson
    ... >> cents/litre for regular, as I recall. ... Their nifty marketing concept was three grades, and the price ... > almost-nonexistent profit margins at the gas pump (even as they post ... the almost-nonexistant profit margins at the gas pump is for the ...
    (rec.autos.driving)
  • Re: Whole Foods overcharge scam?
    ... shows that I was charged the regular $2.29 per bottle. ... I am surprised to here that they bothered passing such a law. ... price $2.29 each" what does that mean, even in consideration of the law ... allows them to charge anything but $1.50 each. ...
    (misc.consumers)
  • Re: Prices
    ... One of the stores where I regularly shop tends to have the best prices ... on chicken and frequently has exceptional sale prices, ... With the price of fuel these days shopping multiple stores defeats the ... week and your regular store will have bacon on sale, ...
    (rec.food.cooking)