Excel Tables - Dynamically naming Table Names?
Is it possible to dynamically name an Excel Table?
Scenario:
I have 100 excel tables in a worksheet. Those tables have employee data - empID, empName etc. Then, I am consolidating all the tables in a consolidated table in masterEmp table using VBA.
If I have to name each excel table manually, it will take me a lot of time. If there was a way to name an excel table linking it to a field in the table ex. empID, then my tables will be named as per empID which is an ideal scenario.
Please help?
Hi abhimails,
I think you are looking for a VBA solution. This site is close to what you want:
https://www.dingbatdata.com/2017/11/...ects-with-vba/
The idea is you can write VBA and access each table on a sheet using it's index number.
Are you sure you have 100 tables on a single sheet? Each table has a blank row and column to set it away from other data? Are you sure?
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Thanks MarvinP for prompt response.
Yes Indeed, I have 100 distinct excel tables in a worksheet. Each table has details of 1 emp with empID, Name etc..
VBA won't serve my purpose as I am trying to name my tables dynamically (each excel tableName will be empID).
Can you show me about 4 of your tables and where the employee ID is in each? Maybe a quick VBA on your data and then remove the VBA might work. Also some sort of FlashFill may also do the trick without VBA.
Call the employee "Name1", "Name2", etc and attach a sample with a short column(s) or row(s) of what you have. I need to see how you have these arranged on your sheet.
Are you sure you have version 2007 of Excel as naming tables got different in newer versions of excel. Read:
https://support.office.com/en-us/art...2-44D21233B114
Marvin, its Excel 2019.. it shows 2007 as default version if not updated. Sorry, I am new here..
Attachment 675777
Please update your user profile (it's not a default setting - you filled it in when you first joined the forum, so please change it now).
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks