Agreed - and point noted.

However there are reasons for splitting the sheets into 3 sections.

Firstly to restrict access to certain users. i.e. only certain users
can update reference data.
and secondly because combining the files would make them unwieldly.

Any others takers?


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=390539