Link to home
Start Free TrialLog in
Avatar of Elmo Erasmus
Elmo ErasmusFlag for Namibia

asked on

Add a label to the Ribbon in Excel to display a changing total

Hi All
I am using Excel 2010. What I want to do is the following in an Excel workbook I have numerous worksheets. In one of the sheets (Sheet1) I have a pivot table that with a total in it that I currently display in a floating user form when I’m working on sheets2 to sheetX. Since the total will change depending on what is done in the other sheets is necessary to view this total the whole time to monitor any changes and to see if the change will be acceptable. Is there a way to add a Label or something similar to the ribbon to display this total?
Thanks in advance
Elmo
ASKER CERTIFIED SOLUTION
Avatar of Steve
Steve
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hello,

you could open a new window (View > New Window), then arrange the windows, so the window with the summary is visible next to the window where you flick from sheet to sheet.

cheers, teylyn