title: Select top-n rows in table after filter with VBA
body: <p>It seems that applying filter to a table has destroyed my understanding of how to handle this.</p>
  
  <p>I have a table with multiple columns.  I'm going to filter on one of the columns and sort on another.  After that, I want to select/copy the first 10 rows of specific columns of what's filtered into another table.</p>
  
  <p>I could easily do this before filters.  I need the first 10 rows AFTER the filter is applied.  I'm not seeing how to choose the 10th row AFTER a filter.</p>
  
  <p>Can anyone point me to a VBA reference that explains how to do this?  Do I need to use SQL to do this?  Am I over thinking this and making it too complicated?</p>