Tom I appreciate the help but Justin was right, although that select
only the individual fields in Column C, when I copy and paste it copy
the entire column.

Justin that macro you posted does pretty much what I wanted, I can jus
copy column H (which I changed to B) But I have another question. Can
change:

Do While Range("G" & x).Value < ""
If Range("G" & x).Value = "1"

to use the column I currently have selected instead of manually havin
to change G to a different column? there's about 50 different columns
have to run this macro for

--
madbunn
-----------------------------------------------------------------------
madbunny's Profile: http://www.excelforum.com/member.php...fo&userid=3254
View this thread: http://www.excelforum.com/showthread.php?threadid=52325