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