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 wi...
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.