Report

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

Ask a question jlcorte14 2Posts Wednesday January 20, 2016Registration date January 20, 2016 Last seen - Last answered on Jan 20, 2016 04:23PM
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 
Helpful
+3
moins plus
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

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!