showing results at the begging of a long worksheet
showing results at the begging of a long worksheet
(OP)
I have a pretty large worksheet that is about 32 pages long. The first two pages define some units and the required inputs. Throughout the worksheet are some results I would like to show alongside the inputs so I don't have to scroll through the whole worksheet to find them. I tried placing the result variables next to the input variables and doing referencing the big worksheet itself-but it didn't work. There must be a clever way to do this. Any ideas? I'm not sure if its important or not but within the workwheet 5 other worksheets are referenced.
RE: showing results at the begging of a long worksheet
RE: showing results at the begging of a long worksheet
RE: showing results at the begging of a long worksheet
Normal variables can only be viewed after they are defined.
RE: showing results at the begging of a long worksheet
One way to manage the size of your apparent sheet is place stuff that you don't necessarily want to see all the time in regions and collapse the regions.
Alternately, you can place the input definitions near the results and use global definition to cast the definition back to the beginning of the sheet.
TTFN
RE: showing results at the begging of a long worksheet
IRStuff - Whenever I collapse an area, I find that the regions inside the collapsed area don't recalculate. Is there some switch that I need to reset?
RE: showing results at the begging of a long worksheet
IRstuff & Jmiec - I plan to try the collapsing technique today. I'll post the results.
RE: showing results at the begging of a long worksheet