I am trying to create a box or window where I can make changes to certian
cells and see how changing those numbers will affect the results on another
section of the spread sheet. I created a P&L sheet that ties to assumptions
on another sheet but don't like toggling back and for to see the results. I
have created a small results box on the main sheet but I can't seem to get a
split view to work so I can view those resutls no matter where I navigate on
the top sheet. Can iI create some kind of display or pop up that I can keep
in one corner and always see the results of the changes I make?

Well the only thing I can think of is select the cell that contains the
result that you want to monitor and then right-click Add Watch

hope this helps!

Thanks Ed, that does work to some degree. I was hoping to keep my 'Results
Box' in the window with the formating etc. But that is much closer to
anything else I've tried.

Jeroamd

"Ed" wrote:

Well the only thing I can think of is select the cell that contains the
result that you want to monitor and then right-click Add Watch

hope this helps!

not elegant, but you could insert a blank chart; add some text boxes to
the chart to point to your data (click on the chart background
anywhere, type = and point to your cell)

then unforunately you need a bit of VBA code to move the chart to the
top left of the window every time you scroll around

try this one for a start point
http://www.ozgrid.com/VBA/limit-scrolling-vba.htm


--
baxybaxy
------------------------------------------------------------------------
baxybaxy's Profile: http://www.excelforum.com/member.php...o&userid=35824
View this thread: http://www.excelforum.com/showthread...hreadid=555809