Hello,
I copied a worksheet and this has named all tables incorrectly is there a way to automatically change the name of all tables in a worksheet?
I have 28 tables for each day of the week
each table has 4 columns:
Index, code, shift, (and names of the days eg table 1 MON1 table 2 TUE2 etc)
Ive typed the department name in a1 called ANAES
Is it possible to change all of the tables in the active worksheet to correspond with the dept name and the day of the week found in column 4?
so the end result is
eg wk1
table 1 = tabANAESMON1
table2 =tabANAESTUE1
etc for all of the rest of the days of the week
then for the next week change the names to
eg wk2
Table renamed to =tabANAESMON2
tabTUES2
etc
and continue for the remaining tables
wk3
tabANAESMON3
wk 4
tabANAESMON4
thank you for any help you can provide
I copied a worksheet and this has named all tables incorrectly is there a way to automatically change the name of all tables in a worksheet?
I have 28 tables for each day of the week
each table has 4 columns:
Index, code, shift, (and names of the days eg table 1 MON1 table 2 TUE2 etc)
Ive typed the department name in a1 called ANAES
Is it possible to change all of the tables in the active worksheet to correspond with the dept name and the day of the week found in column 4?
so the end result is
eg wk1
table 1 = tabANAESMON1
table2 =tabANAESTUE1
etc for all of the rest of the days of the week
then for the next week change the names to
eg wk2
Table renamed to =tabANAESMON2
tabTUES2
etc
and continue for the remaining tables
wk3
tabANAESMON3
wk 4
tabANAESMON4
thank you for any help you can provide