Forum Discussion

Alfred Hull's avatar
Alfred Hull
Copper Contributor
Oct 20, 2017

Auto List: similar to dynamic amortization


I have an issue I'm trying to work out with MS EXCEL, 2016, Windows 10, PC. I have data in an Excel workbook on one sheet downloaded from my organizations ERP system and another sheet being used to build a dashboard. In the dashboard I need to create an auto generated list (similar to an amortization schedule) when a certain drop down element is selected (for example: Standard Document #), and listed below.

For example:

Selection --- Standard Document #: N0003917WX00711

Returned Data --- (below)

N0003917WX00711 SPARES. 1,000,000.00
N0003917WX00711. SATELITE. 2,000,000.00
N0003917WX00711. LABOR. 500,000.00

Once I selected: N0003917WX00711, I would need the corresponding three elements above (which are different) to auto list out underneath the selection cell. Because this particular document only had three every row under this election would be blank. Another Document perhaps may have more elements. Would you happen to have run across this before or know how to do it?
BI & Data Analytics
Requests

1 Reply

  • Yury Tokarev's avatar
    Yury Tokarev
    Iron Contributor
    Oct 23, 2017

    Hi Alfred, 

     

    you can use Power Query for your task. If you could send me a sample of your source data, I can quickly compile an example solution for you to have a look at. 

     

    Thanks

    Yury

Resources