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

Watch MrExcel Video

This Week's Hot Topics

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 MrExcel.com.
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 "mrexcel.com".
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
Top