Selecting top 15 records for multiple selections via VBA

[Eric_G]

Here is my challenge:

- I start with a long listing of records (a listing of securities, for
example), each sorted by a) the Fund which holds the security (as referenced
in Column B) and then sorted by b) the weight (in descending order) of the
security weight within each Fund (as referenced in Column C)
- For each Fund, I wish to select the first 15 records which meet a specific
criteria (for example, which are defined as security type = 111 as defined by
column D); this may mean selecting up to 20-25 records in total as long as
I've selected at least 15 which meet the "security type = 111" criteria
- I then wish to "copy and paste" these 15 records for each fund to another
worksheet.

Any ideas would be appreciated.

Thanks,
Eric

 

[Joel]

You want to use AutoFilter and then copy using SpecialCells method copying
only the visible cells from the auto filter. You can get to special cells
method fro the worksheet froom the menu

Edit - Go To - Special - Select Visible.

You can use either a macro or do it manually.