Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do i set up a 3d reference where one cell reference is dynamic | Excel Discussion (Misc queries) | |||
Dynamic reference to another tab name | Excel Worksheet Functions | |||
Word with embedded Excel object which has reference to addin | Excel Discussion (Misc queries) | |||
I want to be able to create a dynamic reference in excel, for exam | Excel Worksheet Functions | |||
Dynamic reference to sheet name | Excel Worksheet Functions |