Adding a loop to conditional delete code

[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

 

[maw via OfficeKB.com]

Hi Bernie,

That's how I have done this in the past, using the manual autofilters, it was
just that this was the first of a series of larger samples (up to 150,000
rows each) and I thought there must be a better/quicker way of doing it using
a macro,

Thanks

Mark