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

jlcorte14 2 Posts Wednesday January 20, 2016Registration date January 20, 2016 Last seen - Jan 20, 2016 at 02:51 PM - Latest reply: Ambucias 53263 Posts Monday February 1, 2010Registration dateModeratorStatus July 19, 2018 Last seen
- 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
Ambucias 53263 Posts Monday February 1, 2010Registration dateModeratorStatus July 19, 2018 Last seen - 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 1676 users this month