Hi,

Thanks for your help. I actually have a large series of data (multiple
columns) and the process will need to be repeated quite a few times, so
I'm trying to find an automated solution. i.e.

name column1 c2 c3 c4 c5
john 3 3 4 -4 0
jeff 0 2 0 1 9

I need to have a separate list for each column, so sorting won't work
(there are quite a few columns based on the same names to the left).
Therefore, in my worksheet for column one, I want to pull the names and
numbers (not the zeros) that appear in that column. Then, I have a
separate worksheet for column 2, etc. Does that explain it better?

Thanks!


--
cd22
------------------------------------------------------------------------
cd22's Profile: http://www.excelforum.com/member.php...o&userid=32151
View this thread: http://www.excelforum.com/showthread...hreadid=519018