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 |
All times are GMT +1. The time now is 02:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com