is this impossible
 

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 chargin
bands it would auto select the calcs that pertain to it,
a second idear was to duplicate the form (simple booking form)ont
three sheets and once the band is selected it would auto switch sheet
as i said not sure which would be best ,if however there are any othe
ways of achiving this i would welcome the advice

( bearing mind i am no coder) not to say i cant copy sombody elses cod
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 advanc

--
kevat
-----------------------------------------------------------------------
kevatt's Profile: http://www.excelforum.com/member.php...fo&userid=3024
View this thread: http://www.excelforum.com/showthread.php?threadid=50627

is this impossible
 

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

is this impossible
 

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(s heet1!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" wrote in
message ...

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