Forum Discussion
Sumarize the sheetnames
Dear Experts, How can I summarize the sheet names in a Particular Worksheet:- For example:- In below case in the sheet named 38.101-2, I want the summary of all sheet names befor...
Is it me or you didn't provide the complete picture? Looking at your sheetnames they ressemble to the default names when importing pages/tables from a PDF file, ex.:
If you imported from a PDF this is a none-issue. Just put together the appropriate query to summarize the Tables & Pages:
Actually I think I understand what they want and something I think Excel needs to add:
Suggestion: https://feedbackportal.microsoft.com/feedback/idea/172764e2-9c7a-ed11-a81b-000d3ae32cd0
That said, you can get sheetnames using the CELL function and a bit of a formula but that only work for locally saved excel files or using a macro (only works on desktop app) and maybe using a script.
To do it using the CELL('filename') approach you will need to have that formula on each tab and then this tab can pull all those values. A macro (or a script) will require the use of a button or some trigger to execute.
The additional need to split those tab names into 2 columns can be handled with the text functions.
Please clarify a) are you using Excel365 (if not which version)
b) does this functionality need to work online?
c) is the file saved locally?
d) are macros allowed?
Suggestion: https://feedbackportal.microsoft.com/feedback/idea/172764e2-9c7a-ed11-a81b-000d3ae32cd0
That said, you can get sheetnames using the CELL function and a bit of a formula but that only work for locally saved excel files or using a macro (only works on desktop app) and maybe using a script.
To do it using the CELL('filename') approach you will need to have that formula on each tab and then this tab can pull all those values. A macro (or a script) will require the use of a button or some trigger to execute.
The additional need to split those tab names into 2 columns can be handled with the text functions.
Please clarify a) are you using Excel365 (if not which version)
b) does this functionality need to work online?
c) is the file saved locally?
d) are macros allowed?
