View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
william4444[_3_] william4444[_3_] is offline
external usenet poster
 
Posts: 1
Default Extracting Top 5 & Bottom 5 Variances using a Macro Button


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 |
+-------------------------------------------------------------------+

--
william4444
------------------------------------------------------------------------
william4444's Profile: http://www.excelforum.com/member.php...o&userid=33991
View this thread: http://www.excelforum.com/showthread...hreadid=554815