Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup for multie tabs
Hello all,
Workbook has multiple tabs (4-25+). All the tabs are setup in the same format and layout. User will put an X in column N, O or P as a data indicator. I need to have a tab that will give me information from column G if N, O or P has an X in the column. I would like to have one tab show me all the data from the tabs that are in the workbook and be able to add more tabs if need. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lookup for multie tabs
Creayte a new worksheet called summary. The macro will look at all
worksheets except Summary and copy the data from column G into this worksheet. Sub Summary() With Sheets("Summary") .Cells.clearcontenets SumRow = 1 End With For Each Sht In Sheets If Sht.Name < "Summary" Then With Sht LastRow = .Range("G" & Rows.Count).End(xlUp).Row For RowCount = 1 To LastRow If UCase(.Range("N" & RowCount)) = "X" Or _ UCase(.Range("O" & RowCount)) = "X" Or _ UCase(.Range("P" & RowCount)) = "X" Then Sheets("Summary").Range("A" & SumRow) = _ .Range("G" & RowCount) SumRow = SumRow + 1 End If Next RowCount End With End If Next Sht End Sub "pgarcia" wrote: Hello all, Workbook has multiple tabs (4-25+). All the tabs are setup in the same format and layout. User will put an X in column N, O or P as a data indicator. I need to have a tab that will give me information from column G if N, O or P has an X in the column. I would like to have one tab show me all the data from the tabs that are in the workbook and be able to add more tabs if need. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Does a formula exist that will lookup on ALL tabs, not just one. | Excel Discussion (Misc queries) | |||
V lookup in separate TABS! | Excel Discussion (Misc queries) | |||
Lookup mulitple tabs | Excel Worksheet Functions | |||
search all tabs for tab name specified & lookup reference? | Excel Worksheet Functions | |||
Compare tabs using Double Lookup, in VB code | Excel Programming |