You could record a macro while doing it manually.

--
Don Guillett
SalesAid Software

"proxy_cypher"
wrote in message
news:proxy_cypher.1pz2me_1117670707.1313@excelforu m-nospam.com...

Well, actually, after playing with a bit, it really came down to me just
using a autofilter on the column, copying the data to a new sheet. It
worked out fine with no problems.I think i tried to make things more
complicated then they should have been. Granted, I'm positive a VBA
macro could have been created as well, but the whole manual process
took me all of 3 minutes to do.

But, i'll be back with more questions on VBA. You can count on it.


--
proxy_cypher
------------------------------------------------------------------------
proxy_cypher's Profile:
http://www.excelforum.com/member.php...o&userid=23322
View this thread: http://www.excelforum.com/showthread...hreadid=375798