Selecting row of filtered data, pasting it, then moving down and selecting the next row

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)

Thank you!

Works perfectly apart from it says

"Cell" is not a defined variable

Any ideas?