Loop Range, Copy Cell if Row contains "xyz". Next row...

[artvindustries]

So i need to Loop a range, well say A3:CZ2000. Header row is 2. If the loops finds "xyz" it copies the header cell in that column.

Example:

T17 contains "xyz", T2 is copied and pasted to another worksheet along with a few other cells from that row
Next loop
BC24 contains "xyz", BC2 is copied and pasted to another worksheet along with a few other cells from that row

Please Login or Register  to view this content.

Im at a loss for how to bring all this together

[JBeaucaire]

A small workbook with two sheets... one with a 10-20 rows of sample data in the exact format, the other with the manual mockup of the RESULTS you want from that sample data...

That will get you a proper 100% ready to use answer, and quickly since no one will have to create a wb to test their ideas on.


Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[artvindustries]

Thanks! Ill do that right now.

[artvindustries]

ExampleDataAndResult.xlsx

Here you go, hopefully that helps!

[artvindustries]

Heck I'd even appreciate if someone could tell me how to properly reference a range using a variable as the row, like:

Please Login or Register  to view this content.

Im sure this is possible, just dont know how to do it

[JBeaucaire]

Quotations are used to separate pieces of strings, then the & operator connects them.

Please Login or Register  to view this content.

[AB33]

The output is in sheet3

[artvindustries]

This was great thank you so much for your time!

[artvindustries]

The output is in sheet3

I am getting an Error 9 however. on this line

Please Login or Register  to view this content.

Subscript out of range. Any ideas? There are are a few more columns in my original spreadsheet that i omitted.