Insert cell values into footer??

[dwayneh]

Hi,
Ive searched through the posts here but cant find exactly what I need to do. I want to insert cell values of A1 & M47 on the right footer of the "first" printed page, but as my columns fill down to 91 pages, I want the next printed page to increment and display the value of the first row/first column and last row/last column for that page??? I hope the picture helps?

Any help is appreciated

[ravishankar]

HI
Enter values in cell A1 and M48. check footer.
Ravi

[dwayneh]

Thanks, i see the values in the footer activated when you select the work sheet. This is exactly what I want for the first page of the print out, but how do I get the second and subsequent pages to display the cell value of first row/first column and last row/last column of that page? For example, page 2 of my print should read 10329 - 10657.