PFA
On Tuesday, August 23, 2016 2:35 PM, Pravin Gunjal
wrote:
Dear Gaurav
Thanks for solution. You have created a sheet viz. Tab-Names and then used two
macros based on requirement.
But my worry is that in every month number of sheets are getting changed and I
believe the codes can ru
Hi Gaurav
Checked once again and it's working fine. Thanks :)
Need one more help with the same subject.
In "Tab-Names" sheet, can we insert B1 cell of all the sheets along with
sheet names in a column.
*With regards,**Pravin Gunjal*
*Mobile: 77100 *
*97250*
On Tue, Aug 23, 2016 at 4:27 PM, G
What do you mean by 49 sheets. I don't think this code have such
functionality not to work more than 49 sheets. I am sure you are confused
with the code written inside. but still let me know your opinion about 49
sheets.
On Tue, Aug 23, 2016 at 3:04 AM, Pravin Gunjal wrote:
> Dear Gaurav
>
> Tha
Dear Gaurav
Thanks for solution. You have created a sheet viz. *Tab-Names *and then
used two macros based on requirement.
But my worry is that in every month number of sheets are getting changed
and I believe the codes can run only up to 49 sheets. Please check and
advise.
*With regards,**Pravi
Dear Friends,
Greetings!
Could you please teach me how to rename multiple sheets in a single shot
with different name of each sheet.
Any tool/formula/VB is welcome. Thanks,
Example:
1. Gather all sheet names in a new sheet in the same file
2. In the next column type new names (which are to be
