Avatar of Andreas Hermle
Andreas Hermle
Flag for Germany asked on

Retrieve Names of Smart Tables And Corresponding Worksheets

Dear Experts:

My current workbook is a multi-worksheet workbook.

All of these worksheets (with the exception of a worksheet named 'Overview) contain smart tables which I have named such aus 'MT_Surgery' or ' CT_Scissors' etc.

I now would like to retrieve all the names of these smart tables along with their location, i.e. which worksheet these named smart tables reside in.

This data is to be compiled in the worksheet named Overview.

So the result should look like this in the worksheet called 'Overview'


I guess this can only be achieved using a macro.

Help is very much appreciated. Thank you very much in advance.

Regards, Andreas
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Subodh Tiwari (Neeraj)

8/22/2022 - Mon
Subodh Tiwari (Neeraj)

How is your question different from your last question?
Andreas Hermle

It differs as follows:

My last question was based on the assumption that all the named smart tables have been filled in manually in Column B of the 'Overview' Worksheet.

The new question asks the experts to also retrieve the user-defined names of the smart tables.

Thank you .
Subodh Tiwari (Neeraj)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Andreas Hermle

Great coding Subodh, I really appreciate your expertise :-) Thank you very much.

That is exactly how I wanted it.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Subodh Tiwari (Neeraj)

You're welcome Andreas!
Thanks for the feedback. :)