Autofilter at row 4 and copy filtered visible rows from 6 and futher on

[DirkPH]

Hi All,

I am struggling to get certain rows copied from sheet "Data" into another workbook with autofilter.

I want to autofilter --> row 4 --> field 170 --> "<>" --> and copy all visible lines starting from row 5. Then I want to paste these visible lines as value into another workbook also at row 5.
Preferably there should not be any limitation regarding the rows.

Do you have any suggestions?

Thank you!
BR, Dirk

 

[JW00]

No problem, I think we both learnt a bit, all the best with your project.