Thursday, August 18, 2011

How do I name tabs in excel worksheet by using previous tab as a guide to naming my tabs in ascending order?

for example, on my first tab, I have "TX-1052, 2nd tab TX-1053... and I have to rename 250 tabs that currently read, "OK-1052 and so on. I do not want to have to rename 250 tabs. Is there a way to rename all 250 tabs by using "OK-1052.... and which will write the next 250 as OK-1053, OK-1054 and so on?

No comments:

Post a Comment