Hi

I am trying to change sheet 1 into sheet 2 form

ie. sheet one is


date 15/7 16/7 ...
andrew E R
john R E
mary w R
Jim R w etc

to

date E W R R
15/7 andrew mary john jim
16/7 john jim andrew mary etc

I know what to do with the E and W's (as there are only one ), but
problem
with R's

andrewm


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