1. TheMacroNoob

    VBA code to Rename tables on duplicated sheet with sheet name appended

    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...
  2. U

    Help VBA code for adding new name + existing name in Tabs/Sheets

    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...
  3. J

    Renaming Sheets automatically

    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
  4. M

    VBA Automation Error

    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...
  5. Jambi46n2

    Renaming Workbooks based on Cell Value with VBA

    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 =...
  6. T

    Renaming fields in PowerQuery

    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?
  7. E

    Prebuild strategies

    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...
  8. K

    VBA to save sheets in new file

    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...
  9. P

    Renaming Multiple Tabs

    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, ...
  10. W

    Copying sheet multiple times while renaming certain ones

    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...
  11. K

    Help with Renaming Tab

    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...
  12. E

    How to Stop deleting a worksheet however ALLOW Renaming the worksheet?

    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...
  13. K

    Workbooks to tabs

    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
  14. S

    Renaming files using column reference

    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...
  15. B

    Renaming Multiple Folders With Excel

    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...
  16. M

    Auto renaming sheet, warning if name exists

    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...
  17. D

    Modify Button Images?

    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...
  18. I

    Copying Sales sheet and renaming the sheets according to the name coloumn in the Basic Sheet

    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...
  19. A

    Renaming Named Ranges with VBA

    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...
  20. E

    Rename Tab Monthly to a fixed cell reference on 31 sheets

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back