I have been given a worksheet to print that will consist of 300 a4
pages.

What I would like to do is take the value of 2 cells from each page and
print them in the header for that page. This will allow a simple
indexing system without having to examine each page.

The pages are identical in layout and the same 2 cells will be used
from each page.

I have tried the standard 'cell in header' but that would print the
same info on every page. Is there a way to do this automatically?

I have never done macros in excel so all help will be appreciated.

Thanks

Ron.


--
Ronbmy
------------------------------------------------------------------------
Ronbmy's Profile: http://www.excelforum.com/member.php...o&userid=24164
View this thread: http://www.excelforum.com/showthread...hreadid=379477