Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Track tabs
I'm tracking applcations in a report I send to various managers. Each
application has its own tab (ex. ABC, CDE, EFG, HIJ), but not all tabs will be present for each manager. Manager A's workbook might have ABC, CDE, and Manager B's might only have HIJ. I'd like to create an index tab that will lists all possible tabs and indicate with a YES or NO whether or not the manager has that tab listed. Is there a way to do this? For example, Manager A's index would look like this: ABC YES CDE YES EFG NO HIJ NO Manager B's index tab: ABC NO CDE NO EFG NO HIJ Yes Thanks! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Track tabs
If I understand what you want, the following should do the trick:
Option Explicit Sub index() Dim indexselection As Range Dim l, h, i As Long Dim firstsheet As Worksheet With Range("A1") l = Range(.Offset(0, 0), .End(xlDown)).Rows.Count End With Set firstsheet = ActiveSheet Set indexselection = Range("A1") For h = 1 To l For i = 1 To ActiveWorkbook.Sheets.Count On Error Resume Next If ActiveSheet.Name Like indexselection.Value Then indexselection.Offset(0, 1).Value = "Yes" Exit For Else: indexselection.Offset(0, 1).Value = "No" ActiveSheet.Next.Select End If Next i firstsheet.Select Set indexselection = indexselection.Offset(1, 0) Next h End Sub -- -SA "Nico" wrote: I'm tracking applcations in a report I send to various managers. Each application has its own tab (ex. ABC, CDE, EFG, HIJ), but not all tabs will be present for each manager. Manager A's workbook might have ABC, CDE, and Manager B's might only have HIJ. I'd like to create an index tab that will lists all possible tabs and indicate with a YES or NO whether or not the manager has that tab listed. Is there a way to do this? For example, Manager A's index would look like this: ABC YES CDE YES EFG NO HIJ NO Manager B's index tab: ABC NO CDE NO EFG NO HIJ Yes Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I alphabetize the tabs on a spreadsheet with 25 tabs? | Excel Worksheet Functions | |||
How do I alphabetize the tabs on a spreadsheet with 25 tabs? | Excel Worksheet Functions | |||
tabs are missing even though 'tools-options-view-sheet tabs' ok? | Excel Worksheet Functions | |||
hide tabs from view then lock tabs? | Excel Discussion (Misc queries) | |||
"Track Changes" - Prevent turn off track changes to meet SOX regs | Excel Discussion (Misc queries) |