Hi,

I have an excel sheet with titles and summary data at the top of a
sheet, then a long list of data (rent collections -amount date
etc)going down the page. This list is for monthly collection so gets
longer with time as I add to it.

I need a printout on a single sheet of paper displaying the summary
data at the top, then in the available space below the most recent rent
collections.

In other words on screen the summary will always be shown and the
collections will scroll as I keep adding to it, so when I print, what
is printed is what is on screen.

I think it is something to do with split screen (just below summary
data at top) then being able to set the print window so it is not
static, it prints what is shown on screen

thanks

Paul


--
PaulHelyer
------------------------------------------------------------------------
PaulHelyer's Profile: http://www.excelforum.com/member.php...o&userid=31716
View this thread: http://www.excelforum.com/showthread...hreadid=514189