chem101
10-14-2010, 10:12 AM
Hello Everyone,
I have a workbook that I setup for use in my office for pricing our products. On one of the worksheets I setup a table with customer information, name address etc. On the data entry worksheet the user can access this customer list via a drop down window. The problem I'm having is with the drop down list. When you click the drop down arrow on the data entry worksheet, the drop down window appears to be empty.
The drop down window appears blank because it's showing the line after the last line of data in the table. The bottom of the customer list is just on click up on the drop down window. Is there a way to get this drop down window to show the top of the list instead of the bottom?
Thank you in advance for your help!!
I have a workbook that I setup for use in my office for pricing our products. On one of the worksheets I setup a table with customer information, name address etc. On the data entry worksheet the user can access this customer list via a drop down window. The problem I'm having is with the drop down list. When you click the drop down arrow on the data entry worksheet, the drop down window appears to be empty.
The drop down window appears blank because it's showing the line after the last line of data in the table. The bottom of the customer list is just on click up on the drop down window. Is there a way to get this drop down window to show the top of the list instead of the bottom?
Thank you in advance for your help!!