Forum Discussion
Adding Data from another Worksheet depending on a Dropdown List selection
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 dow...
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 :).
Hi Nikolino,
Thank you for responding. Appreciate your time to have a look at my query.
I've reviewed your example, I don't think it achieves what I looking to do. I'm happy to arrange a Teams call with you so I can explain what I mean.
When I make the selections from the drop down menus in the first screen shot, the relevant data from the other tabs in the workbook should pull through and display itself in the main tab. Then the user can edit the data the main tab.
My plan is to hide all of the other tabs. and just have the main tab visable. If I have to use VBA code that's fine.
Thank you for responding. Appreciate your time to have a look at my query.
I've reviewed your example, I don't think it achieves what I looking to do. I'm happy to arrange a Teams call with you so I can explain what I mean.
When I make the selections from the drop down menus in the first screen shot, the relevant data from the other tabs in the workbook should pull through and display itself in the main tab. Then the user can edit the data the main tab.
My plan is to hide all of the other tabs. and just have the main tab visable. If I have to use VBA code that's fine.