Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
variances | Excel Discussion (Misc queries) | |||
Add button to bottom of spreadsheet to delete blank lines auto | Excel Discussion (Misc queries) | |||
Extracting Top 5 & Bottom 5 Variance for Revenu/Expendenture & Net Position | New Users to Excel | |||
Extracting Top 5 & Bottom 5 Variance for Revenu/Expendenture & Net Position | New Users to Excel | |||
Pause macro, add form button to sheet, continue macro when button clicked! | Excel Programming |