View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TimS TimS is offline
external usenet poster
 
Posts: 6
Default Dynamic reference of word doc in excel

I am creating a master table in Excel that lists several word documents in
columns, then items down the rows. What I want to do is have Excel keep track
of the dynamic page number in the cell.

So I have a handbook for pilots and on page 6 it refers to flight planning.
In the excel spreadsheet, the column would be "pilot Handbook" and the row
would be "flight planning" and I want the cell to say "6" for page 6. It
would be nice to reference paragraph number too, but that seems a tad much.
If, after revision, the flight planning paragraph moves to page 8, I want
that to auto update in the spreadsheet.

I know it is possible to make a master index file, but the spreadsheet is
the requested format by the evaluating authority so I'd like to automate the
process if possible. Thank you,

Tim
Santa Rosa, CA