Link to home
Start Free TrialLog in
Avatar of Andreas Hermle
Andreas HermleFlag 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'


User generated image
I guess this can only be achieved using a macro.

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

Regards, Andreas
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

How is your question different from your last question?
Avatar of 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 .
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Great coding Subodh, I really appreciate your expertise :-) Thank you very much.

That is exactly how I wanted it.
You're welcome Andreas!
Thanks for the feedback. :)