Okay thats getting very close to what i want.

However. The table on the right hand side, won't have anything filled
in. The information comes from the table on the left. The table on the
right effectively summarises the info taken on the left.

Therefore, the names on the table on the right cannot be fixed. They
have to be taken from the table as well.


--
PhilK
------------------------------------------------------------------------
PhilK's Profile: http://www.excelforum.com/member.php...o&userid=34665
View this thread: http://www.excelforum.com/showthread...hreadid=545093