Always show a hovering Result Table in every worksheet

[shermansee]

I have a file in which I want the user to be able to monitor the impact of changes to variables without having to keep going back to a summary worksheet to see the impact.


Basically I would like to set up a small "Result Table" that will hover at the side of each worksheet (regardless of whether the user is scrolling up or down, the position of the table remain "static" in Excel). That way, the user can easily see the impact from the said Result Table when any variable is edited in the worksheet.


Is this possible?

 

[NARAYANK991]

Hi ,


You can add a Watch Window ; this is available under the Formulas menu item.


Narayan

 

[Hui]

Or you can have two or more windows open in the same file

Position them so one always shows rhe results


Or if it is on the same worksheet you can split the screen or use view windows

 

[kalpesh39]

Hui sir,

i want to put references from rows to columns in a work book is this possible?

for ex. i put name of collection center in a column & dates in rows now i want separate sheets for each collection center with columns date & data given under date in sheet1


please help