One way is simply to cut row600* and paste into a new sheet (or link it in
the new sheet to point to row600). Name that sheet as say: Summary. No more
need to scroll anywhere <g. I find it neater to use another sheet for
summary lines. And I could always piece summary lines from various
"data-only" sheets.

*assumes that the max expected extent of data within the source sheet falls
within the range covered by the original formulas in row600.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Greg" wrote:

I have to copy between 400-500 rows of data daily. Because numbers of rows
changes on daily basis I set my calculations (countif, avg,%) around row
#600. Is there is a way to create some kind of pop-up box that will display
all results so I dont have to scroll to the end of a spreadsheet? Thanks