Forum Discussion

anupambit1797's avatar
anupambit1797
Steel Contributor
Dec 21, 2023
Solved

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...
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Dec 21, 2023

    Hi anupambit1797 

     

    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: