I need to set up a report that dynamically displays on another sheet items
from one column of a filtered range. After the advanced filter is executed,
I may have 12 records left showing out of the 400. On sheet2 I need to
display the visible data from one of the columns, let's say in cells A1:A12.
So this would be one of those "copy down" functions that displays the first
item in A1, the second in A2, etc. I've been tinkering with all the INDEX,
OFFSET, SUBTOTAL combinations, but am not quite getting it.

TIA