What I provided does what you ask.

If you wanted to replace the 1's in column G with the corresponding value
in column C, then that certainly isn't what you stated.

--
Regards,
Tom Ogilvy


"madbunny" wrote in
message ...

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

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

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

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


--
madbunny
------------------------------------------------------------------------
madbunny's Profile:
http://www.excelforum.com/member.php...o&userid=32541
View this thread: http://www.excelforum.com/showthread...hreadid=523253