I have been trying to create a combo box that contains names of clients (which change dynamically as new clients are added) to generate their data into an invoice. The issue is that each named range associated with a client contains several rows of data, so I can't simply make a "Client" column without leaving several blank cells.
This is what the data looks like; further client entries have the same Cost Codes, but use different pricing and other factors per code:
Account Data.PNG
I tried to create a separate named range for clients with the formula:
But despite COUNTA ignoring blanks, I get blanks (or 0's when testing it in a worksheet) instead of the client names that should be further underneath:Please Login or Register to view this content.
ComboBox.png
Output.PNG
Is there an easier way to approach this? If I make each client table a named range, can a combo box contain a list of those named ranges to refer to? I feel like I'm missing something obvious, and I need help
Bookmarks