Thu 9 Sep 2010, 14:55Delegate Tashi said...
Tashi has attended:
No courses
Rename worksheet after Cell value
How do I rename the different worksheets in 1 excel spreadsheet after the value in the cell E13??
Alternatively how can I ensure that the value in E13 is the same as the name of the worksheet?
I have 600 worksheets in 1 spreadsheet and so don't want to have to do it manually!
Sat 11 Sep 2010, 08:30Trainer Anthony said...
RE: Rename worksheet after Cell value
Hi Tashi, thanks for your query. There is no built-in functionality to do this in Excel, so you will need to write some code to achieve this. The following forum post is an example of the sort of thing you'll need to write:
http://www.mrexcel.com/forum/showthread.php?t=45692
...but let me know if you need any further guidance on this.
Hope this helps,
Anthony
