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