I am looking for a formula that will copy a visible cell from a filtered dataset in another worksheet (see attached sample for filtered example).
I want to create a table in another worksheet that contains cell ($A$1,1) to cell ($A$1+4,1) from the filtered data where N refers to another cell that contains which visible row to start from.
if $A$1 contains the value 3, then the first cell in the new table would contain the 3rd visible item in column 1 from the filtered data. The second cell in the new table would contain the 4th visible item in column 1 from the filtered data, etc.
Hopefully that makes sense.