In a spreadsheet I have set up a summary document that pulls all the data out
and puts it in a report format. On the report sheet there are headings where
I have range named the cell.
On a seprate sheet I have the index page where I idendify the headings in
one column and the corresponding page number (in the Report sheet). At the
moment I manually enter the page number on the Index but if the Report layout
changes I need to go back in a redo the page index.
Is there a way of pulling out the page number that the range named cell is
on to automatically update the index sheet?