nth table name in previous worksheer

[theseven]

hi,

I am trying to rename tables in worksheet based on table names in previous worksheet; For this, i need to obtain table names from last worksheet?

Actually, i need to replace specific part of table name of previous worksheet for new name: for eg: if it was xyz_123 in previous worksheet, i want it as abc_123 in new worksheet. What is the best way to do this?

Thanks in advance!

 

[shcon]

So did you copy the worksheet? If so you can go to formula tab, under "define name" click on name manager then you will see a list of table name that will include name of table in original sheet and copied sheet so you can select which one you like to rename and then click on edit. A new name is depend on you...

 

[theseven]

hi, I am so sorry that i did not mention: I have many tables in each worksheet. So, i am looking for a vba to do this