Use a formula.

Use Data validation.

See previous answers.

--
Regards,
Tom Ogilvy


"kevatt" wrote in
message ...

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