A
Albert Sim
I have got 2 workbook. book1.xls is for application and book2.xls is a database that looks like this
A B
Name1 CompanyA Address
Name2 CompanyB Address
Name3 Company C Address
In book1.xls cell B1, I want to create a drop down list (data validation) making reference to book2.xls column A, i.e. when cellB1 is focus, I will see Name1, Name2, Name3 in the drop down list. How can I achieve this
A B
Name1 CompanyA Address
Name2 CompanyB Address
Name3 Company C Address
In book1.xls cell B1, I want to create a drop down list (data validation) making reference to book2.xls column A, i.e. when cellB1 is focus, I will see Name1, Name2, Name3 in the drop down list. How can I achieve this