ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Set Table Name = Worksheet Name (https://www.excelbanter.com/excel-discussion-misc-queries/242019-set-table-name-%3D-worksheet-name.html)

TKS_Mark

Set Table Name = Worksheet Name
 
I have worksheets that have one table on them. I'd like the table name to
match the worksheet name so a lookup can work automatically instead of
manually. Is it possible to have the table name update with the sheet name
it's on. I'm talking about the new table functions that came with Excel 2007.

Thanks.


All times are GMT +1. The time now is 08:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com