Is there any way to make table names local?

[JenniferMurphy]

I often need to have multiple copies of a sheet, such as for different years. But when I make a copy of a sheet containing a table, Excel renames the table by adding a number. This is because Excel makes all table names global. If the name I gave to the table in the first sheet was "TableRatings", the name in the new sheet might be "TableRatings4" and in the next copy of the sheet, it might be "TableRatings45".

This causes me some problems. If I need to add a new column that will contain any references to data in the table, I am never sure which table is in this sheet.

This does not happen with local names.

I wish Excel allowed me to decide whether the table name should be local or global. Is there any way to do that?

 

[JenniferMurphy]

justl expressions. ???

What are expressions?

As Mark explained, I meant an excutable expression (or equation or formula). My point was that I am not using VBA code, which is what your post contains. So I was asking how it answers my question about how to make table names local.

Is that clearer? Can you elaborate or explain how your reply (that code) addresses my question?

Thanks

 

[My Aswer Is This]

I was just thinking of using the Table Listobjectnumber and not the Listobject name

Like Sheets("Alpha").Listobjects(1)
Not sure that would help you.