Argh!

LOL!

Confusing!

Very!

Can I see your file?

Biff

"dgraham" wrote in
message ...

Thanks again Biff,

That works, now is there a way of getting the the shed location for the
cell reference ie.. shed!B3 refers to 1D in the shed and shed!C3 refers
to 1C in the shed. there are 4 spots in each row ranging from 1A to
44D. for example

bus 900 is entered at $C$28 and this cell refers to the shed number
26C. and the 26C is what I would like printed in Location! Column C. so
when I have finished entering all the buses, the shed address ie.. 26C
will correspond to the Shift bus# in Location! column B. Confusing!


Regards

David


--
dgraham
------------------------------------------------------------------------
dgraham's Profile:
http://www.excelforum.com/member.php...o&userid=33138
View this thread: http://www.excelforum.com/showthread...hreadid=530335