Hi All,

I need to:

Select the next row down from A9

Selection A:S

Then Paste into another sheet (I can do this bit)

Then select next row

repeat

I can normally do this, however because its filtered I can't get it to work,

Any ideas?

At the moment its selecting specific cells of the filtered data (I recorded the macro)