Updating a dropdown list from a table in another sheet.

[rp4717]

I am using office 365 to create my invoice for my business. The invoice is on Sheet1. I am currently using a drop down list for my customers. The drop list is from a Table that I created in Sheet2. I am trying to get that drop list on sheet 1 to update as I add customers to the table in Sheet2. I have not been able to find a way that works. Any help would be appreciated. Thanks.

 

[Peter_SSs]

Welcome to the MrExcel board!

If you have not done so already, make the customer list table on Sheet2 into a formal Excel table (Insert ribbon tab -> Table)

Here is mine - it is called Table2

rp4717.xlsm
	A
1	Customer Name
2	Cust 1
3	Cust 2
4	Cust 3
5	Cust 4
6	Cust 5
7	Cust 6
8	Cust 7
Sheet2

Then on Sheet1, set up your Data Validation drop-down list like this.

rp4717.xlsm
	A
1
2	Cust 3
3
4	Cust 4
5
6
7
8
9
10
Sheet1

Cells with Data Validation
Cell	Allow	Criteria
A2:A10	List	=INDIRECT("Table2[Customer Name]")

 

[rp4717]

Thank you so much!!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.