rename sheet names

Hi all, I have another issue with working with multiple worksheet when trying to copy data from specific column (formula) to another column and paste as values for multiple sheets. The sheets layout are build the same way and the sheets name will be changed during the process which is why the...

Dear all, I'm trying to create a macro for my excel file where I want it to rename sheets name based on a certain range in one sheets and each cell value will refer to a specific sheet number Attached an example excel file I want to use the value in the sheet ProjectInfo range between B20:B29...

just a quick question, is there a way to rename sheet name if workbook contains certain string? i.e. MainOfficeReport.xls if it contains the word "office" in the workbook name then change the sheet name to Office BTW, default sheetname for all report have the same name thus the need to change...

Hello everyone, This is my first time posting on here, and I'm very new to Excel VBA code, so I would appreciate some help. I have an Excel workbook with 7 sheets. The 1st one is a reference sheet titled Allocation, where I type in names of accounts into cells A3:A5. For the purpose of this...

Can you please help me on this. How to rename sheet name in multiple workbooks in a folder to some other name. Ex: Multiple workbooks are in a folder. "Sheet1" is the common name in all the workbooks. This "Sheet1" to be renamed as "TaxCalc"

I have a report that is run in an external tool and produces an Excel file. The file contains 1 sheet, and that sheet is always named something different because a timestamp and some other variables are used to generate the sheet name. I want to use a macro to clean up the report and rename the...

I create a dynamic named range for certain cells in one of my sheets. The problem is when user changes the name of that sheet. So, I decide to make VBA code which will run when sheet changes, but I can not make it done right. My dynamic named range is: MyBooks and its formula is: =OFFSET('Book...