is this impossible

[kevatt]

need to be able to select a charging band

i thought using a dropdown list or combo box would be the way

IE: band A charged at one rate
band B charged at another
band C Charged at another

i thought what would be very nice if when i select one of the charging bands it would auto select the calcs that pertain to it,
a second idear was to duplicate the form (simple booking form)onto three sheets and once the band is selected it would auto switch sheets as i said not sure which would be best ,if however there are any other ways of achiving this i would welcome the advice

( bearing mind i am no coder) not to say i cant copy sombody elses code to which i am asking for !how do i achive my goal

to all that helped in the past all of the info supplied has been great

a big thanx once again advance

[[email protected]]

Hi
You have written a couple of vague ideas about an approach to some
vague problem. Not much to go on is it?!
regards
Paul

[Tom Ogilvy]

You can use Data Validation to place a dropdown box in a cell.

You can then have conditional formulas to perform the calculation.

Assume the selection in made in Sheet1!B5

then you can have formulas like

=if(sheet1!B5="","",if(sheet1!B5="A",formula1,if(sheet1!B5="B",formulaB,if(s
heet1!B5="C",FormulaC,"Invalid"))))

Another way would be if you have various values associated with each band.
On an additional sheet you could have a lookup table

Assume Sheet5!A1:D4 an an example

Item1 Item2 Item3
A .5 3 2
B .75 1 .5
C 1.5 2 1



then in your formula you could use

=Index(Sheet5!B2:D4,Match(Sheet1!B5,Sheet5!:$A2:A4,0),Match(Sheet1!F6,Sheet5
!B1:D1,0))*Rest_of_Formula

Where Sheet1!F6 contains the "item" you are addressing or hard code the name
of the "item"

--
Regards,
Tom Ogilvy


--
Regards,
Tom Ogilvy

"kevatt" <[email protected]> wrote in
message news:[email protected]...
>
> need to be able to select a charging band
>
> i thought using a dropdown list or combo box would be the way
>
> IE: band A charged at one rate
> band B charged at another
> band C Charged at another
>
> i thought what would be very nice if when i select one of the charging
> bands it would auto select the calcs that pertain to it,
> a second idear was to duplicate the form (simple booking form)onto
> three sheets and once the band is selected it would auto switch sheets
> as i said not sure which would be best ,if however there are any other
> ways of achiving this i would welcome the advice
>
> ( bearing mind i am no coder) not to say i cant copy sombody elses code
> to which i am asking for !how do i achive my goal
>
> to all that helped in the past all of the info supplied has been great
>
> a big thanx once again advance
>
>
> --
> kevatt
> ------------------------------------------------------------------------
> kevatt's Profile:
http://www.excelforum.com/member.php...o&userid=30245
> View this thread: http://www.excelforum.com/showthread...hreadid=506277
>