Forum Discussion
How to add company address with drop down
I have a workbook that I want to use for invoices. It has 2 pages the Invoice and customers. been working on it but cannot figure out how to add the customer name and address to the BILL TO: area with a drop down. On the second page I have two simple address's and will add more customers to the list in the future I will attach the workbook if anyone can give it a shot and help me out.. thanks
2 Replies
See the attached version. Since your customer list is a table, the drop down list will be updated automatically when you add new rows to the table.
I've attached a workable solution. You'll need to adjust the DataValidation and various formulas to accommodate the final dimensions of your table. But otherwise, I think this is doing what you want. Let us know if you have questions or difficulties making sense of it.
