Hello

I have a workbook that has 20 worksheets.

I have 3 buttons on each work sheet that sort out 3 columns (revenue, name, sale item).
-it works perfectly fine.

I have also created a "hidden" master sheet that extracts data from each worksheet, from all 20 sheets (it's a basic link ..i.e. =Rep1!A10)
-the range is from (A10:R59) for all worksheets, so my master worksheet approx 1000 lines.

Finally,
-I have a worksheet in the book that is titled "top 50";
is there a formula or method that I can use to show "top 50" based on revenue, name and sale items? can someone pls help, it's been really hampering my work.

my code in the module for the sort button is simple
Please Login or Register  to view this content.
I have tried to copy that formula, rename the macro into masterworksheet but keep getting an error, it's not linking the macro, help pls!