Hi,

Zygy you may be right. But it is all about looking creatively at the
problem. You can only do this from your position where you know how the
spreadsheet is to be used, by whom, and how it will be updated.

A couple of suggestions:
1. I tend to put totals, averages etc to the top and left of a
spreadsheet because you can then use the freeze-panes optyion to keep
these on display while scrolling through the detail.

2. You could use blank rows (between say 35 and 99) and hide them. Only
un-hiding when the rows need to be populated.

Hope this helps


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=552892