Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filtering the Column headers that contains data for resources
I have an excel with the following information
A1 - Is a dropdown which will have names of the systems (EAI,Mediation,CDF ...,All) Row2 will be header which will have following data B2 - Project Id C2 - System ID D2 - Project name E2 - Project Phase F2 - Status from g2 to GN2 there are about 60 resources names entered From C3 to F3 the data wil be entered and appropriately a chk mark will be made to the corresponding resource wroking on that project Say i have about 10 systems provided as dropdown for entering data in A1 (Ex: EAI, MEdiation, .....) There are resources working for each system My question is now when i apply filtering on a system name i shoud be able to show only those resources working for that system and all others should be hidden Also under the "system" dropdown i will have an option "All", when "All" option is selected i should be able to see all the data for all the systems. EX: if i take system "EAI" and if the resources working for eai are there in AO2 to AX2 then i want the resources from AX2 onwards and before AO2 not to be shown. If i take a system "Mediation" and if its resources are from Z2 to AI2 then i want resources before Z2 and after AI2 notto be shown. If "All" option is chosen then i should be able to see the whole sheet with all the data for all the systems and all resources. Can anyone throw light on this with a macro. Hope i am clear. IF this can also be achieved in a simpler way please do let me know |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lookup using column headers and row headers | Excel Discussion (Misc queries) | |||
Two Headers, one subject column and various columns with data | Charts and Charting in Excel | |||
Find last column with data, but with headers and a total row | Excel Discussion (Misc queries) | |||
Excel can not complete this task with available resources. Choose less data or close other applications. | Excel Discussion (Misc queries) | |||
trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions |