rename sheet

  1. R

    VBA to Rename Worksheets Based on Contents in Sheet 1

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

    VBA code for copy sheet

    Hello, I write next code to copy active sheet, is working but: - i need to: - switch it in ActiveSh, new created copy; - counting cell A14 start from 1. to 999. on each copy; - counting cell D16 start from 001 to 999 on each copy; - counting of sheet is not...
  3. I

    Rename Sheets based on cell values from the first sheet in the workbook.

    Hi, I'm very new to VBA. I have a problem figuring out how to do a macro. I want to rename sheets in my workbook based on values from specific cells on the first page (the front page). Is there someone who can maybe give me some advice. For example I want to put in values in G3, G4, G5, that...
  4. B

    How do I rename a sheet without knowing in advance what it's called?

    I know how to rename a sheet when I already know what the sheet name is going to be. For example I geta weekly file from an external source and I rename it as follows. 'Rename sheet in Study Summary Workbooks.Open Filename:= _ "G:\Database\Database files\Study Summary.xlsx"...
  5. A

    Copying a Template and rename worksheets from a range in main worksheet as date

    I am new to vba. Trying to write code to generate copies from a template worksheet and name the copies from a range in primary worksheet. The ws tabs should be in a date format. So far I was able to generate the copies from the template and it makes the amount of copies in the range, but instead...
  6. D

    Rename a worksheet using a formula

    Hello. I want to rename my worksheet with today's date preceded by the letters LB (space). I've been tinkering with the syntax of this statement for a while and I can't get it to work. ActiveSheet.Name = "=""LB ""&TEXT(TODAY(),""YYYY-MM-DD"")" If I place the above formula in a cell...
  7. A

    Rename sheet - throws Out of memory error

    Below code gives me out of memory error. Workbooks("Sheets1").Activate Worksheets.Add before:=Sheets("Sheets1") ActiveSheet.Name = "ABC" I have added below lines to my code in order to free memory Application.DisplayAlerts = False Application.CutCopyMode = False Application.ScreenUpdating =...
  8. A

    Renaming Multiple Worksheets

    Hello, I have a workbook full of order sheets, I am attempting to figure out a code that will automatically generate the name of sheet based on one cells' value (ex. W9). However; if they cell should be empty, I would like it to keep the name as Sheet1 or Sheet2, etc. Attempted to find sources...
  9. JoCook

    Rename tabs from dailog box with dates

    I am trying to create a macro that will rename all tabs that have been named with a date mm-dd-yyyy. I would like a dialog box to pop up and ask for a starting date and then have the macro find the tab names with the lowest date and then rename them to the next years dates For example current...
  10. D

    Optimising Macro to auto add new sheets and rename based on a columns criteria but excluding one specific entry

    Hi! I am am looking for some much needed help but please bear with me as I am a complete novice and only joined Mrexcel today! Using windows 7 with Excel 2013 but would like this to run on previous versions also. The following is what I would ideally like: I have a workbook with 2 worksheets...
  11. Gingertrees

    Renaming a sheet copied from another workbook, errors ensue...

    Gaaah! Working on a macro to copy in a sheet from a daily report, into my "processing" workbook. The daily report worksheet to-be-copied will always be called "orange", so I figured when I copy it, I'll rename it "orange" + the number of sheets in the workbook (orange5 when sheets.count=5...
  12. A

    using a macro to rename a sheet based on date

    I have a workbook with a over 100 sheets and at the end I have a template where I have a macro that copies the template and does some work with pivot tables and it is working well. What I would like have happen is for the new sheet (Template(2)) to be named in mmddyy form one business day after...
  13. D

    Copy worksheet, buttons and all and rename

    Hello All, I have searched without success to find code I could adapt to what I want to do. I want to copy my existing worksheet (named "2014") including the command buttons and the code that goes with them, to a new worksheet (named "2015") and so on every year. And I would like this to happen...
  14. M

    Rename sheet by Cell value

    In this code, if the cell value is having some special characters like "/" etc, it showing error. I need to exclude that error and remove the special character in the particular cell and rename as it is. Example : B1 cell is having " ABC/ DCF" While renaming the sheet, it should come as " ABC...
  15. F

    Using VBA to rename select worksheets based upon a cell value in each sheet?

    Hello ALL! I am a VBA greenhorn and need assistance in renaming (11) select worksheets in an excel workbook that containd based upon a cell value in each sheet. This forum does have several posts relating to this same problem; however, no posts address naming specific sheets as well as where...
  16. V

    (VBA) Duplicate sheet and rename the copied sheet

    Hi, I'm trying to feed information from a MSProject file to an excel workbook. I want that for every uncompleted task that is a non-summary task, that I duplicate a sheet in the excel workbook and rename it to the Text1 field value of the task. The template sheet is the 2nd sheet and is named...
  17. M

    Move rows to another sheet based on criteria and rename sheet based on data

    Hi The code posted by texaslynn in the link below works perfectly for the beginning of what I'm trying to do. However, I already have a tab with a name that matches one of the data names in the column that is being broken out. When the macro runs, the already created tab is overwritten with...
  18. E

    VBA to Filter copy and paste results to new sheet and rename

    Hi, I'm learning VBA slowly but this has me stumped! I have a worksheet which I need to filter by Column E for every criteria listed and copy the results to a new sheet - named after the value in Column E. Then delete the data from the original sheet. I attempted this: Sub Chopper() ' '...
  19. S

    Rename tabs as cell A2, for every sheet

    Hi guys, I have the below code,renaming each tab as A2 & "Transactions" but on sheet 2 it is still trying to use cell A2 from the sheet 1, I need to pick up A2 from each sheet while active, any suggestions please? Also do you know how I can start from just the second sheet please? Thanks...
  20. N

    Automatically rename sheet to a date in that sheet

    I've tried to figure this out on my own and I keep getting the same error.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p> I'm trying to copy a template sheet I've made and rename it to a date that is displayed in the new sheet. I keep getting...

Some videos you may like

This Week's Hot Topics

Top