LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do i set up a 3d reference where one cell reference is dynamic SmilingSteve Excel Discussion (Misc queries) 15 March 14th 08 05:05 AM
Dynamic reference to another tab name Angus Excel Worksheet Functions 5 February 9th 07 05:41 PM
Word with embedded Excel object which has reference to addin Tom Chau Excel Discussion (Misc queries) 0 September 6th 06 02:25 AM
I want to be able to create a dynamic reference in excel, for exam Lee Excel Worksheet Functions 4 April 5th 06 05:51 AM
Dynamic reference to sheet name Darien0104 Excel Worksheet Functions 1 May 8th 05 09:41 AM


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"