renaming

Hello excel experts, I have a VBA code via the magic of ChatGPT: Sub DuplicateTemplateSheet() Dim templateSheet As Worksheet Dim newSheet As Worksheet Dim sheetList As Worksheet Dim sheetName As String Dim lastRow As Long Dim i As Long Dim tbl As ListObject ' Set a reference to the Template...

Hi Guys, Need help here on adding new name + existing name in tabs/sheets. I am looking for a piece of code that can help me with my work. I want to add new set of numbers on the existing tabs. for example project ID is 2214 : (this are may tab names) 143 188 122 11 901 After the code runs i...

Hello, I have a workbook with a few hundred sheets in it. Is there an easy way to rename each sheet using the contents of cell A3 on each sheet? Also, is there a way to automatically delete columns L - Q on every sheet? thanks Jon

All of a sudden one of my macro workbooks starts producing an Automation error when I execute this command: Sheets("Categories").select The rest of the error message is "Invalid forward reference, or reference to uncompiled type". I tried renaming the tab and I've verified there is nothing...

The code below works with renaming workbooks, however it also moves them as well. Is there a way to modify the code to make a copy of the workbook instead of moving it? Thanks much in advance! Sub RenameTesting() Dim OldName1, NewName1 'Work books based on cell values below OldName1 =...

When I load an Excel sheet in PowerBI, I was attempting to rename the fields in PowerQuery by filtering out the fields and renaming the ones I want to by replacing the values However, I cannot retrieve the fields that I filtered out. What is the proper way to do this?

Every year our organization holds a large concours car show. Every year "they" change something in the format in some way that requires me to tweak my spreadsheet. I am looking for a strategy were I am not renaming ranges etc. I am looking for labeling/name strategy that is more flexible. Any...

I'm trying to save an individual worksheet in a certain location and renaming the new worksheet to a specific cell. The workbook consists of 10 tabs of which I only require the tab 'User Form' to be saved as a separate workbook and renamed to the text in cell B4. I've managed to save the...

I have hundreds of tabs in an excel file all labeled with #1 and so on. How would I go about renaming all the tabs in one go to just getting them numbered such as 1, 2, 3, ...

First time posting here, but have found many answers to questions by searching before. Hoping someone might have an answer on how to do the following: 1. I have a locked sheet that has very limited abilities to format anything due to a macro that allows uploading to a specific database. 2. Need...

Hey Guys, I want to rename tabs based on 2 seperate cell values, I have the macro for renaming based on the one cell value but i can't figure out how to add another cell value on top so that both values are used in the renaming of the tab. I need to use the cell C2 value and A3 value...

I have a spreadsheet with 50 worksheets. The information from 49 of those feeds into the 50th worksheet. I am wary that someone could delete one of the 49 worksheets and the calculations can go awry. How do i stop someone from deleting the worksheet HOWEVER allowing them to still rename the...

Hey guys, Is there a macro for selecting multiple workbooks and then bring them to a new workbook in tabs? I have about 2000+ workbooks that I am currently copying and pasting and renaming each tab and it’s a pain! Any help is appreciated

I would like to have a VBA code that would rename files (both excel and pdf) in a specific path. The files in the path are initially named as 1, 2, 3, 4... etc. Now the template that has the VBA will have the exact number of files with the number series in Column A. While in Column B, I will...

Hi everyone. I am looking for some help on renaming multiple folders on our network drive. Each folder has the name of a specific project. I need to change that name to a unique code that correlates with that project. Ideally, I would have an excel sheet with column A being the folder names and...

I am currently using the following code: Sub CopyTable() Sheets("Brongegevens").Select Sheets("Brongegevens").Copy After:=Sheets(1) ActiveSheet.Name = Range("CodeCopyTabblad").Value End Sub This code copies a worksheet, and then renames it to whatever value is in the named range...

Hi There used to be a way to modify custom buttons and I wondered if this was still possible? I've added some macros to my quick access toolbar and also the ribbon. Renaming and assigning a symbol is easy enough, except none of the available symbols quite fit what the macros are for. Can the...

Dear All, I need your urgent help in the following case: Here I have a sales sheet and I rename it according to each sales man. I need a VBA code to copy the sales sheet and renaming it according to the sales men name listed in the names column in the basic sheet as attached. so, I need to...

Hi, I have a template sheet that contains a number of named ranges that I want to make unique when I copy the sheet, but I'm having trouble with it and could use some help. Let me explain The Template Sheet contains named ranges like xxx_var1 xxx_thingy2 I have a function to copy the sheet...

Hi, I am new to this forum and haven't posted but more searched and tried to find a solution to what I need and I haven't found quite what I need so I will post and hope I can get an answer. I have 6 status sheets that have each working day (6 branches) that show how many payments were Money...