ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Data Validation using VBA to reference to another book (https://www.excelbanter.com/excel-programming/289560-data-validation-using-vba-reference-another-book.html)

Albert Sim

Data Validation using VBA to reference to another book
 
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




All times are GMT +1. The time now is 01:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com