That wasn't very well explained. I have a 3 columns of data containing
1000 rows. Each cell shows either a zero or a name of a case, case
number or a name of a person working a case. I desperately need a sub
or a formula to traspose all of the non zero data to another refined
cell range. Can anyone help?


--
MattD
------------------------------------------------------------------------
MattD's Profile: http://www.excelforum.com/member.php...o&userid=28405
View this thread: http://www.excelforum.com/showthread...hreadid=479965