Macro to rename sheets based on cell value in another sheet [Solved/Closed]

Posts
2
Registration date
Wednesday January 20, 2016
Last seen
January 20, 2016
- Jan 20, 2016 at 02:51 PM - Latest reply:
Posts
55840
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
November 20, 2018
- Jan 20, 2016 at 04:23 PM
I am attempting to rename 5 sheets in a workbook based on values from a sheet titled Raw Data Information. The first sheet should be named based on 'Raw Data Information'!C2 then the next based on 'Raw Data Information'!C3 and so on. I can't seem to make this work. I can only find code that will work for me if it referneces a cell on the same active page. Can anyone help?
See more 

1 reply

Best answer
Posts
55840
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
November 20, 2018
Jan 20, 2016 at 04:23 PM
1
Thank you
Greetings,

Please, bare in mind that CCM is a mutual aid community, all answers on the forum are provided by volunteers who give their time free to help solve issues.

Therefore, it is specifically requested from CCM forum users to correspond showing mutual respect. Therefore, when requesting assistance, it is suggested to be courteous, as for elsewhere in similar circumstances. (i.e. please, thank you, appreciate, grateful, etc.)

http://ccm.net/contents/ccmguide/ccmcharte-respect-autrui.php3#politesse

Please, copy, modify and repost your message respecting the politeness charter.

We trust that you understand.

Moderator

Thank you, Ambucias 1

Something to say? Add comment

CCM has helped 1692 users this month