I don't quite understand. Can you elaborate?
andrewm Wrote:
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
--
Domenic
------------------------------------------------------------------------
Domenic's Profile:
http://www.excelforum.com/member.php...o&userid=10785
View this thread:
http://www.excelforum.com/showthread...hreadid=387140