Copying Different Rows from Different Sheets into one sheet

[Toncat]

Hi
I want to copy rows depending on columm criteria (Columm J >0) from 10
different Sheets, into one Sheet. Hope that someone now how to do it.

 

[Jef Gorbach]

Will try to get you som sample code during lunch, but in general:
for each sh in worksheets
autofilter(column J > 0)
copy visual rows
paste to bottom of target sheet
next