Copy & Paste Specially Conditionally

[unit213]

Anyone ever run across some VBA code that will copy/paste special an entire row if a certain criteria is met?

I have a few thousand rows that contain "cust req" in Column A. For each occurence of that, I'd like to copy/paste special the entire row.

Any ideas?

 

[Oaktree]

Try data --> filter --> autofilter and copy & paste the results of your filter.

 

[unit213]

I tried that. It's not working thus my post.

 

[unit213]

I'm recording a macro that copies/pastes special each row at a time. It's tedious, but it seems to be working.