Is it possible to change the macro below so that it copies all the
values in column2 corresponding to same value in column1 and paste them
in different worksheet on row with same value as in column1 but while
pasting I want to take a transpose (convert column data into row)??

Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=520616