Dynamic List in MS Excel 1

[DSerr77]

Does anyone know how to go about creating a list or report in excel that would have the ability to auto populate from a master table after the user choose criteria from multiple drop down boxes? Appreciate any help!

 

[SkipVought]

Hi,

Yes! I do it often!

1. Results from drop downs go in separate cells.

2. Data/Get External Data/new Database Query -- Excel Files -- YOUR WORKBOOK containing the Master Table (assuming that it's in Excel) -- the Sheet that the master table is on -- [Next],[Next],[Next], Check the OPTION to EDIT in MS Query [Finish]

3. In MS Query QBE Grid, add criteria(e) that will come from your drop downs with VALUES like [Enter Cuntomer ID]

4. File/Return results to Excel

5. Before finishing, select parameters whatever -- You'll see the [Enter Cuntomer ID] etc in the list. For each one select option 3, referenc the appropriate cell containing the dd data. On the LAST cell you might want to check the box that will FIRE the query on value change (or do it for each one)

VOLA!

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}

 

[DSerr77]

Skip,

Can you tell me if the steps you provided are possible with excel 97. I am having trouble implementing your suggestion.

 

[SkipVought]

How far have you gotten in the process?

Skip,

_{[red]Be advised:[/red] When you ignite a firecracker in a bowl of vanilla, chocolate & strawberry ice cream, you get...
Neopolitan Blownapart!}