• 0

[VBA in Excel] Merge and Filter two columns


Question

I have a workbook with 3 worksheets. Each worksheet has a table of 10 numbers (Table 1, 2 and 3 for example.) I need to merge the two tables then filter them numerically once merged for just the top 10 results. I have managed to merge the two tables together but cannot then filter them numerically.

I only need the After speaking with a few people they recommended a macro to look through the two tables and add the top 10 highest values to an array then write the values into the new table. This seems like a good idea but Im no good at VBA so need help.

Thanks very much in advance

Link to comment
Share on other sites

1 answer to this question

Recommended Posts

  • 0

You can use the AutoFilter methods of a range to create a filtered table:

post-92970-12650165404215_thumb.png

With Sheet1
    .AutoFilterMode = False
    .Range("A1:C4").AutoFilter
End With

post-92970-12650166062521_thumb.png

Hope that helps.

Link to comment
Share on other sites

This topic is now closed to further replies.
  • Recently Browsing   0 members

    • No registered users viewing this page.