matratus34
Board Regular
- Joined
- Nov 21, 2013
- Messages
- 74
Hi all,
I've got a report that calculates various outputs based on the user selecting a customer from a drop down box in cell B6 on my tab.
The report uses the customer selection in B6 to populate various SUMIFS and VLOOKUPs formulas to produce results in a table.
Everything works perfectly - but my problem is that the dropdown is set up using a Data Validation List of 250 customers and when the user wants to make their selection the box for the selections is quite small and only shows 8 customers without scrolling.
If I add a Combo Box to my tab instead of using the Data Validation then the box for selecting the customer is much larger and easier to navigate for the user, but is there an easy way to get all my formulas to reference the Combo Box selection rather than the dropdown I'm using at the moment?
All help is greatly appreciated.
I've got a report that calculates various outputs based on the user selecting a customer from a drop down box in cell B6 on my tab.
The report uses the customer selection in B6 to populate various SUMIFS and VLOOKUPs formulas to produce results in a table.
Everything works perfectly - but my problem is that the dropdown is set up using a Data Validation List of 250 customers and when the user wants to make their selection the box for the selections is quite small and only shows 8 customers without scrolling.
If I add a Combo Box to my tab instead of using the Data Validation then the box for selecting the customer is much larger and easier to navigate for the user, but is there an easy way to get all my formulas to reference the Combo Box selection rather than the dropdown I'm using at the moment?
All help is greatly appreciated.