I'd like to include the value from the 1st or last row of each page in the
header of an Excel spreadsheet.
E.g. If the first column contains a date, and there is a page change after
each month, I'd like to be able to have a Header text like "Report for the
month of [=TEXT(A*i, "mmm-yy")]"
where A*i is the "first-row-of-current-page" respectively.
In other words, if 40 rows fit on each page and cell A1 contains the date
1-Jan-2005 and cells A2-A80 contain dates in Jan-05 while A81-A100 contain
dates in Feb-05 and A101-200 contain dates in Mar-05 then then header for
pages 1+2 should read "for the month of Jan-05", that of pg.3 should read
"for the month of Feb-05", and that of pages 4-5 should read "for the month
of Mar-05"