naming tabs

  1. C

    Is it possible to auto name a tab within a workbook based on a cell reference?

    I have several budgeting workbooks in Excel 2003 that are used by my companies field staff to input data. The inputs they choose within the header creates a unique budget number and each tab within the workbook represents a single unique budget. I currently have the field staff "copying" and...
  2. zakasnak

    Tab color based on list

    Could I color the tabs based on a list in a sheet? I have a breakout code that breaks out a sheet into multiples: Sub CopyToNewSheetsByGroup2() Dim strName As String, i As Integer Dim UsedRng As Range, rng As Range, FRng As Range, R As Range, c As Range, sh As Worksheet Dim HdrBoo As...
  3. S

    Creating a new tab and tab name using data from another sheet

    I am trying to create new tabs in a workbook using data from sheet 1 in that same workbook. I would like each tab name to be the data that is in A1:A162, where A1 is the column heading. I tried the following macro but I kept getting error # 1004. Sub AddSheets() For Each TabName In...
  4. T

    Macro to identify & name tabs based on data in spreadsheet

    Here is my challenge. I am trying to build a macro that will take data and separate it on different tabs based on the date column. It may be the last 6, 12, or even 18 months depending on what the spreadsheet has. I need the macro to determine the names of the separate tabs that would just be...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top