Autofilter help

[Paul T]

Hi all

I have 4 columns of data with an auto filter on - all ok
I then reduce my selection so I finally only have one row of data - all ok

Not ok: Problem: Is there an easy way that I can copy the data in the top
row of the filter, to another worksheet page - so if the filter is changed
so top line shows new result - still copies over the data in the top row of
the filter.

Bearing in mind that the top row could be I.E. Originally Row 8 or 108
depending on the selection.

Autofilter Line = 1 2 3 4
eg Result of A/F a a a a <== copy the result of this line to
different worksheet (this could be row 8 for eg)

however if:
Autofilter Line = 2 1 3 4
eg Result of A/F b c a a <== still copy the result of this line
to different worksheet (this could be row 108 for eg)

I hope you understand. Probably not explained myself clearly.

Thanks

Paul

 

[Paul T]

I have scrapped this idea. thanks for looking.