Jan 02 2023 06:34 AM
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, if i include a new page in my excel table, everything would change in the summary.
You can find below a screenshot, refering to what I am thinking about.
I apologize for my bad english and my lack of knowledge at Excel, I am just a beginner on it.
Thank you.
Jan 02 2023 06:53 AM
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.
Jan 02 2023 07:14 AM
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.
Jan 02 2023 10:28 AM