Need some help with some VBA code...

[proxy_cypher]

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

 

[Don Guillett]

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

--
Don Guillett
SalesAid Software
(e-mail address removed)
"proxy_cypher" <[email protected]>
wrote in message
news[email protected]...

 

[proxy_cypher]

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

 

[Don Guillett]

You could record a macro while doing it manually.

--
Don Guillett
SalesAid Software
(e-mail address removed)
"proxy_cypher" <[email protected]>
wrote in message
news[email protected]...