renaming

  1. 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
  2. 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...
  3. 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 =...
  4. 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?
  5. 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...
  6. 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...
  7. 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, ...
  8. 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...
  9. 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...
  10. 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...
  11. 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
  12. 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...
  13. 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...
  14. 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...
  15. 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...
  16. 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...
  17. 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...
  18. 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...
  19. L

    Help...Multiple workbooks linked to master work book<--huge file; after renaming, loses linked cells

    I really need help in creating a macros. I have a master workbook<--huge file. Project 1 workbook is where the user may pick selection using check box application. Depending on what selection the user chooses in Project 1 workbook, it grabs all picturelookups, formulas, calculations from the...
  20. D

    Renaming Named Ranges

    Hi all, I have a workbook template with a couple dozen named ranges. Since it is a template, I am naming all of the ranges with an XX at the start, i.e. XXmonths or XXcreditdue. When I use the template to load data for a client, I want to change the XX's to the acronym of the client I am...

Some videos you may like

This Week's Hot Topics

Top