Extracting Data from Multiple Worksheets

[andrewc]

Hi,

I have data arranged as in sheets "Firm 1" and "Firm 2".

I would to use a macro, if possible, to extract from "Firm 1" and "Firm 2" the top and bottom 5 products per sector based on their growth rates. A sample outcome is shown in Sheet1.

This has proven to be way beyond my skills.

Can someone please point me in the right direction.

Thanks!

[LeoTaxi]

In Sheet Result

Please Login or Register  to view this content.

In Module

Please Login or Register  to view this content.

Kind regards
Leo

[jindon]

Updates the list, each time the Sheet1 is selected.
Or Alt + F8 and select "test" then Run
1) To a Standard code module

Please Login or Register  to view this content.

2) to ThisWorkbook code module

Please Login or Register  to view this content.

3) to Sheet1 code module

Please Login or Register  to view this content.

[andrewc]

Thank you both very much!!!