Forum Discussion

anupambit1797's avatar
anupambit1797
Iron Contributor
Dec 21, 2023

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 22, 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:

     

Lorenzo's avatar
Lorenzo
Silver Contributor
Dec 22, 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:

 

Share