naming tabs

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

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

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

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