Automatic page numbers in TOC
 

Hi,

How to extract the printing page numbers from my worksheets in order to
update my 'table of contents' worksheet automatically?

The sheets are named Part 1, 2, etc. and they all have a 'Part x -
Cover' worksheet. I only want the page numbers of the 'Part x'
worksheets, not for the covers.

I am looking for a solution that doesn't involve having to press a
button or run a macro. In other words a function. Also, because I have
not got to grips with VBA programming, I have placed this thread in the
forum 'Excel Worksheet Functions'.

Thanks!


--
danswa
------------------------------------------------------------------------
danswa's Profile: http://www.excelforum.com/member.php...o&userid=31267
View this thread: http://www.excelforum.com/showthread...hreadid=512171