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
|