I have a column, which i would like to filter and copy the filtered
data to other sheet.
The filter criteria should be the items in the same column.
Like using the auto filter.
I know how to apply Auto filter - Selection.AutoFilter Field:=1,
Criteria1:="xyz", but how to get this "xyz" from the values in that
column?
Should I loop throght the column cells, and somehow filter the items?
I am lost?

Also when looping throught column, how to stop if cell is empty?

thanks