Hi,

Sorry

sheet 1 contains all of -
A B C
1 date 15/7 16/7 ...
2 andrew E R
3 john R E
4 mary w R
5 Jim R W etc

sheet 2

to A B C D
E W R R
15/7 andrew mary john jim
16/7 john jim andrew mary etc



andrewm


--
andrewm
------------------------------------------------------------------------
andrewm's Profile: http://www.excelforum.com/member.php...o&userid=23130
View this thread: http://www.excelforum.com/showthread...hreadid=387140