Extracting Top 5 & Bottom 5 Variances using a Macro Button

W

william4444

Hi All,

I Have an Excel Spreadsheet & within this there are over 40 Sheets
which get Caculated into a sheet called "Analysis" using a Formula
INDirect. I have a Sheet called "Summary" & what i would like is within
this sheet a Macro Button that would only Bring Back from the Sheet
called "Analysis" the Top 5 & Bottom Revenue Variances, Top 5 & Bottom
Expendenture Variances, Top, Top 5 & Bottom Net Position Variances, as
well as the Business Centre Name. Have a look at the attachment as this
is the way i'd like it. Would appreciate all the help.
Thank you
Will


+-------------------------------------------------------------------+
|Filename: Book22.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4929 |
+-------------------------------------------------------------------+
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Top 5 list if data meets a criteria 3
macro to show / hide grouping, linked to label button 3
Creating a Macro Button to Extract Data 4
Extract Outlook mail using VBA from non default Inbox 4
Extract line and copy 0
Creating a Macro Button to Extract Data 0
Creating a Macro Button to Extract Data 2
Creating a Macro Button to Extract Data 1

Top