Dec 10 2022 04:45 AM
Hi Community,
I'm creating a worksheet for project managers to use.
I want the worksheet to be dynamic, so when a certain selection is made from a dropdown list, data will appear below the drop down from another worksheet i've created. If multiple selections are made from other drop downs, the relevant data will appear. Please see screenshots below to get a better idea.
When you make the selection such as the example above, I would like the following to pull through from the other tabs:
I would like the data from the Cloud tab to appear on the Main tab in the space highlighted by the area. If you make a selection from the second dropdown that appears below the cloud data and so on and so forth.
Can this be achieved?
Thanks
Dec 10 2022 06:10 AM
Attached is an example file with dependencies on other dropdowns, maybe it will help you in your projects. Would only have to fit into your project according to your wishes :).
Dec 11 2022 05:37 AM