sujittalukde
04-09-2009, 11:07 PM
The attached file contains two sheets.
First sheet is the Main sheet which contains the Main Group and Sub group data.
Second sheet is the "Report" sheet where cell B! contains a drop downlist.
Now I want to show the name of the members based on cell B1 value starting from cell B3. for eg., if I select "Marketing" in cell B1 then all the members name for "Marketing" should display in cell B3,B4 and so on. I will put the formula till row 50 as at most 50 records could be there.
Help needed to draw the formula for the same. (No macro)
First sheet is the Main sheet which contains the Main Group and Sub group data.
Second sheet is the "Report" sheet where cell B! contains a drop downlist.
Now I want to show the name of the members based on cell B1 value starting from cell B3. for eg., if I select "Marketing" in cell B1 then all the members name for "Marketing" should display in cell B3,B4 and so on. I will put the formula till row 50 as at most 50 records could be there.
Help needed to draw the formula for the same. (No macro)