Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multi tab setup
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.misc
|
|||
|
|||
Multi tab setup
With that many tabs, you probably want to ask that in the programming
section, as VB can loop for the number of worksheets you have. otherwise, you'd have to use lookups, and 25 lookups is not a happy thing... "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 | |||
Multi threaded calculation (multi CPU) - impact on calculation spe | Excel Discussion (Misc queries) | |||
I have a multi what if: | Excel Worksheet Functions | |||
Complex Multi-condition, multi-workbook count | Excel Discussion (Misc queries) | |||
match in multi-column and multi-row array | Excel Discussion (Misc queries) | |||
how can I paste multi-line/multi-paragraph data into ONE cell? | Excel Discussion (Misc queries) |