Forum Discussion
AnthonyMondot
Jan 02, 2023Copper Contributor
Dynamic summary
Hi, I had a question regarding excel, and I could not find the solution on the Internet. I wanted to know if I could make a dynamic summary, including page number at real time. That way, ...
mathetes
Jan 02, 2023Silver Contributor
I suspect that it IS possible, but I do not know the answer for certain in Excel. I know it would be possible in Word, so that's why I assume Excel too can accomplish that.
However, for the sake of others who are still more familiar with the nuances of Excel, may I ask you to elaborate a bit more. Is the full document to which the page numbers refer all contained in Excel, in a single workbook, perhaps with multiple tabs? Is it composed from multiple workbooks? In other words, give us a more complete picture of what lies "behind" this summary index.
- AnthonyMondotJan 02, 2023Copper Contributor
Hello mathetes .
Thank you for your answer. Indeed, i could have been more accurate with my request.
I am refering to one workbook, including multiple tabs.
Depending on the job, I may have to multiply some tabs.
My summary index has to refer every tabs of the workbook, as well as the page numbers.
Example : Organization chart "from 7 to 8"
I hope that this time I was clear enough.
Thank you for your help, it is really appreciated.
- mathetesJan 02, 2023Silver ContributorAnd now I will have to defer to others here on these pages who have more experience with creating reports from that kind of maximum usage of a workbook.