i 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 suer 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=504634