Been given a pretty good task that requires me to work with VBA here.
Which is fine because I need to learn VBA.

I have a workbook with 5 worksheets in it. There is one column that I
need to loop through on all the worksheets. If it comes across a 'x', I
need to copy that row into another, new worksheet.

Would the best way to go about doing this be to use the recorder, or to
hande code VBA? I've played around with the recorder and copied and
pasted to see what the VBE records and it has helped.

Anyone have further suggestionS?

Much thanks.

cypher


--
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

Why don't you post YOUR efforts and we will help from there.

--
Don Guillett
SalesAid Software

"proxy_cypher"
wrote in message
news:proxy_cypher.1pyuah_1117659917.0638@excelforu m-nospam.com...

Been given a pretty good task that requires me to work with VBA here.
Which is fine because I need to learn VBA.

I have a workbook with 5 worksheets in it. There is one column that I
need to loop through on all the worksheets. If it comes across a 'x', I
need to copy that row into another, new worksheet.

Would the best way to go about doing this be to use the recorder, or to
hande code VBA? I've played around with the recorder and copied and
pasted to see what the VBE records and it has helped.

Anyone have further suggestionS?

Much thanks.

cypher


--
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

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

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

--
proxy_cyphe
-----------------------------------------------------------------------
proxy_cypher's Profile: http://www.excelforum.com/member.php...fo&userid=2332
View this thread: http://www.excelforum.com/showthread.php?threadid=37579

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