ecalid
08-24-2023, 03:41 AM
Good morning all,
I am just wondering if there is a way of being able to select from a drop down menu, multiple criteria, for example Dropdown A and Dropdown B, get VBA to then lookup specified columns in another workbook, and then generate a table and populate it with the data found in those columns.
So if there were 40 entries with a specific text in workbook B; "Lamination" in Dropdown A, and then specific text; "FLT driver" in Dropdown B on workbook A, it would generate a table and populate 40 rows in workbook A with the findings in both of those columns in workbook B.
I have tried to use indexing excel code for this but it just isn't practical and the code often gets confused with it's self and brings up multiple entries.
Any advice you can provide will be helpful.
Thanks in advance.
I am just wondering if there is a way of being able to select from a drop down menu, multiple criteria, for example Dropdown A and Dropdown B, get VBA to then lookup specified columns in another workbook, and then generate a table and populate it with the data found in those columns.
So if there were 40 entries with a specific text in workbook B; "Lamination" in Dropdown A, and then specific text; "FLT driver" in Dropdown B on workbook A, it would generate a table and populate 40 rows in workbook A with the findings in both of those columns in workbook B.
I have tried to use indexing excel code for this but it just isn't practical and the code often gets confused with it's self and brings up multiple entries.
Any advice you can provide will be helpful.
Thanks in advance.