compariniaa
06-26-2006, 10:44 AM
I have over 2,000 entries in one spreadsheet, with revenue figures in column
H, and the figures are sorted ascending
To provide the user with a quick overview on a printout, I wanted to
"compress" everything so it would fit onto one landscape-oriented page. By
compress I mean hide the middle values, not zoom out. By hiding the middle
values, only the biggest losers and the biggest gainers are shown.
How could I write a sub that kept hiding the middle rows until only 50 rows are visible?
H, and the figures are sorted ascending
To provide the user with a quick overview on a printout, I wanted to
"compress" everything so it would fit onto one landscape-oriented page. By
compress I mean hide the middle values, not zoom out. By hiding the middle
values, only the biggest losers and the biggest gainers are shown.
How could I write a sub that kept hiding the middle rows until only 50 rows are visible?