Creating switches

[kevatt]

senario:
I have a simple booking form but i have three charging tariffs simple cacls tell me the cost based on the hours this is achived by manually inserting a refrence cost,
for instance:
the hirer wishes to hire a hall fore 3 hours @ £8.50 p/h total £25.50 this is my band (A) tariff now i would like this total (25.50) to be placed into colum A on sheet 2 and so on band (B) & (C) it does not matter if a separate entry is entered on each booking or they are added together giving a single total in each of the tariff colums. By selecting either one of the tariffs on booking form (sheet A) i want the result total to be placed ind corisponding colum on sheet 2

also is there a way of selecting the charging tariff instead of manually entering each time as i feel they may be linked
IE: list box ect

[Tom Ogilvy]

Use a formula.

Use Data validation.

See previous answers.

--
Regards,
Tom Ogilvy


"kevatt" <[email protected]> wrote in
message news:[email protected]...
>
> SENARIO:
> I have a simple booking form but i have three charging tariffs simple
> cacls tell me the cost based on the hours this is achived by manually
> inserting a refrence cost,
> *for instance:*
> the hirer wishes to hire a hall fore 3 hours @ £8.50 p/h total £25.50
> this is my band (A) tariff now i would like this total (25.50) to be
> placed into colum A on sheet 2 and so on band (B) & (C) it does not
> matter if a separate entry is entered on each booking or they are added
> together giving a single total in each of the tariff colums. By
> selecting either one of the tariffs on booking form (sheet A) i want
> the result total to be placed ind corisponding colum on sheet 2
>
> also is there a way of selecting the charging tariff instead of
> manually entering each time as i feel they may be linked
> IE: list box ect
>
>
> --
> kevatt
> ------------------------------------------------------------------------
> kevatt's Profile:
http://www.excelforum.com/member.php...o&userid=30245
> View this thread: http://www.excelforum.com/showthread...hreadid=506547
>