Hello Everybody,

I'm hoping somebody has the solution for this I already browsed through
most of the internet without any luck.

ok so let's say I have an excel spreadsheet:
A1: label1 B1: label2
A2: value1 B2: 1
A3: value2 B3: 1
A4: value3 B4: 3
A5: value4 B5: 1
A6: value5 B6: 3
A7: value6 B7: 1
A8: value7 B8: 3

I select (A1:B8) and click on create list
now I click on the drop down button of label2 and select 3 this shows
only the rows for which label2 value is 3 (basic filtering)

it would show:

A1: label1 B1: label2
A4: value3 B4: 3
A6: value5 B6: 3
A8: value7 B8: 3

OK. now I need to be able to export the filtered sheet either to a text
file, csv file, an excel file, another sheet, with a button.
the usual methods of exporting won't work because they use a for to go
through each row and this would export also the hidden rows.

going into edit-GoTo-Special-Visible Cells Only and then manually
selecting the cells and copying and pasting into another sheet is not
an answer since the spreadsheet will dynamically grow that's why I need
a VBA code that exports the current view of the sheet.

I would really appreciate any suggestions