2 Steps:

1. On worksheet #3 highlight the transpose range, type:
=transpose(range2) and press cntrl&shift +Enter.

range2= the range of the table on worksheet #2 to be transposed.

2. Put your feet up on the table and smile


--
John James
------------------------------------------------------------------------
John James's Profile: http://www.excelforum.com/member.php...o&userid=32690
View this thread: http://www.excelforum.com/showthread...hreadid=531894