Set Table Name = Worksheet Name

T

TKS_Mark

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.
 
D

Dan DeHaven

For it to happen dynamically/automatically it would have to be done wit
a VBA code. Not too tuff of one, but it can't be done directly by Exce
based on any setting.

Dan
 
Top