Hi
I have made a database in excel with different sheets. each sheet has got one table in it. there is a "summary" sheet that I have summarized the data of all sheets in that.
I need to know the name of each table in each sheet automatically. I mean I want to use a function to extract the name of table in each sheet. I searched all of the functions but I did not find any related function. I will be appreciated if somebody can help me.
Best Regards
Rsdoost