tab name

  1. I

    Macro with multiple tabs / copy and paste

    Good Day all, long time / first time I've been on Google the previous day looking at compiling a series of macros to do the following (I will break up in to unique tasks): #1 : scroll through a workbook with 70+ tabs and find a uniquely named tab (that will change spreadsheet to spreadsheet)...
  2. H

    Formula or Macro? Referencing multiple tabs in formula, but excluding other tabs.

    Hi I have a spreadsheet where I want to do some reporting against the data. The majority of it is COUNTIF and SUMIF formulas. The spreadsheet is made up of a few home pages and the rest have the data on them. New tabs can be added and old ones removed so there is not a definite list of tabs to...
  3. E

    Tab Name based on Cell Value

    I have the following code that looks at AC1 and renames the tabs in the entire workbook based on the cell value and if there is no name or any unacceptable characters it gives an error message. I want this to happen only for the active sheet and not to loop through each sheet. I know it is just...
  4. B

    Macro that Ignores Tab/Sheet Name

    I have a macro that is written to pull data from a different tab. This macro will not work if/when a different user changes the name of the tab. How can I change my code to pull the same data regardless of what that tab name is. Portion of current macro Selection.Copy Sheets("Financial...
  5. Terminal

    Worksheet tabs named according to Index worksheet cell values.

    Hi All I have a workbook used for tracking pupil progress, each tab represents a pupil but they are named generically Pupil1 Pupil2 etc. The workbook has an index worksheet which has the students names in a column and hyperlinks next to each name linking to a worksheet. The teacher has asked if...
  6. S

    Rename 4 tabs only based on cell value with VBA

    I have a workbook that has 14 total tabs and I am looking to write VBA to rename only 4 of the 14 tabs. The tabs to be renamed will use cell values on a different tab that contain no illegal characters or length restrictions. I have researched how to write the code, but only found the cell...
  7. E

    Active sheet name to change in sequence by macro

    Hi there, I've got a workbook with two spreadsheets named "WT-1" and "CL-1" (it could be more of them with diff. names). When i.e. "WT-1" is active, I would like to be able to (by using a button with macro assigned to it) copy this current (active) spreadsheet and rename it in sequence like...
  8. J

    Auto Date Columns relative to the Worksheet Name

    Hi, I am after some help in creating an XL (2013) file which will enable me to create a Workbook with Worksheet tab names of Months of the year, also it will add the dates for that particular Month to row 2 within this worksheet. The worksheet will have Personnel Names in column A and the date...
  9. V

    How tab names are separated underneath the hood in Excel? Using FIND function

    Hello! I have found an interesting thread here, in which this formula is used: =INDEX(MID(SheetNames,FIND("]",SheetNames)+1,255),ROWS(A$1:A1)) https://www.mrexcel.com/forum/excel-questions/428957-list-worksheet-names-using-formula.html SheetNames is the name of the whole Workbook, if I...
  10. C

    VBA to open other workbooks based on tab names

    I've been scouring the web and not finding what I need. Also "Excel 2013 Power Programming with VBA" hasn't been able to show me what I need. The code below Is intended to copy data from a range on all tabs except the first one "Skip Me" and paste it into other workbooks. The tabs in "master"...
  11. K

    Run time error 91

    I am developing a spreadsheet for analysing expenses & other costs. The data will be in one of the tabs, the full name of which is not known but we know that the name starts with a known string - in this case "statement". What I want is the end of the name: F_Nam. What have I done wrong ? I...
  12. A

    Automatic Cell name change - Tab name

    Hi guys, I've seen people post how to change a Tab name based on a cell's value/name using a macro, but what I'm looking for is the exact opposite. I need to have a cell's name/value change based on a tab's name. Would appreciate the help. Thank you
  13. R

    If tab becomes hidden then...

    So a have code written in tab 'sheet1'. And Basically if the tab becomes hidden, I want the word 'No' written in the tab 'info'. And when the tab becomes unhidden, I want the word 'Yes' written in the tab 'info'. At the moment, when i unhide/hide 'sheet1' nothing happens. Private Sub...
  14. M

    Allow tab to be renamed when sheet is protected

    Excel 2010. I have a workbook that has 12 copies of the same sheet. I have renamed the tabs 1-12. I have all the sheet protection working just fine. When I protect the sheet, it also protects the Tab Name. I want the users to be able to rename the tab to the last name of the person they are...
  15. E

    Change Tab name based on formula in cell D3 on each sheet

    In every D3 cell I have a date, formatted such as "01-Jan-16." What I want is for the name of each tab to automatically be renamed by pulling this data. The dates in cells D3 are figured by pulling the date in the previous sheet and adding 7 to get the new date (I create a new sheet each...
  16. O

    Moving worksheets to new workbook based on name

    Version: 2007 Hello Everyone, I have a workbook with a "Detail" and "Summary" worksheet. The data in each of these worksheets needs to be split up and grouped into separate tabs based on the value of a specific column (region). Then, the Summary and Detail worksheet for each region needs to be...
  17. A

    Indirect function, to link changing tab name from seperate file

    Hi there, I'm looking for a formula to link back a tab from separate file (file stays the same) but the tab name will be the changing parameter set on what is in cell A1. So for instance: In a file "Z" cell A1=YOY (that's my tab name) Therefore, I would like to link what's in a cell D1 of...
  18. E

    Add data from list to worksheet based on tab name

    Hello, I have a macro that creates a new sheet from a template and renames these tabs based on a list. The template is called "Template" and the list is in column A of a tab named "List". See code below. Sub Copy_Sheets() Dim i As Integer Dim wks As Worksheet Dim Last_Row As Long Set wks =...
  19. P

    Sheet Name VBA

    hy all, i'm got VBA code for taking a sheetname into cell, but problem is it's not run automaticaly, so everytime i change the sheetname the i must recalculated to make the sheetname on cell change. this is the code : Public Function sheetname(ByVal target As Range) sheetname =...
  20. N

    Question about Saving Tabs and stuff in VBA

    Hello everyone, I am a first time poster here, but a long time user of Excel. I have not needed to dabble in macros or VBA until recently, so I'm fairly new with them. Using: Excel 2010 Prominent Cell: H4 = Pay Period Ending Date, drop down list of dates through the PPE 12/6/2013 Current...

Some videos you may like

This Week's Hot Topics

Top