B
Bernie Deitrick
Mark,
If you apply the Data Autofilter and select 16 from the dropdown at the top of the age column, you
will be shown just those rows with 16s.
If you select those cells that are shown and copy them, you can paste them into a new sheet, and
Excel will only paste the rows that were visible when you did the copy. That would keep the rows in
order.
Or we can modify the macro to restore the original order, and allow you to pick the age (or age
range) that you want to see.
HTH,
Bernie
MS Excel MVP
If you apply the Data Autofilter and select 16 from the dropdown at the top of the age column, you
will be shown just those rows with 16s.
If you select those cells that are shown and copy them, you can paste them into a new sheet, and
Excel will only paste the rows that were visible when you did the copy. That would keep the rows in
order.
Or we can modify the macro to restore the original order, and allow you to pick the age (or age
range) that you want to see.
HTH,
Bernie
MS Excel MVP