This Excel VBA Tutorial explains, how to copy and paste filtered data and filtered rows.
Right-click 'Download' and select 'Save Link As' if the file opens in a new tab.
