C
Carl Johnson
I asked this question earlier but as usual I didn't explain very well what I
was trying to do. So I hope this is better.
I have one workbook called custlist with the id #'s and names of customers
which I used to create a range called t_customer.
In a workbook called Invoices I've set up a vlookup function in cell D5 to
find the name of the customer from the id# in cell d2. Since the custlist is
so large I thought that I could use a combo box in D2 using the range
t_customer so that end users would not have to keep referring to the
custlist workbook to retrieve the id #'s. Hope that explains what I'm trying
to do.
How do I link the t_customer table to the combo box.
Any help would be greatly appreciated. Thank you.
was trying to do. So I hope this is better.
I have one workbook called custlist with the id #'s and names of customers
which I used to create a range called t_customer.
In a workbook called Invoices I've set up a vlookup function in cell D5 to
find the name of the customer from the id# in cell d2. Since the custlist is
so large I thought that I could use a combo box in D2 using the range
t_customer so that end users would not have to keep referring to the
custlist workbook to retrieve the id #'s. Hope that explains what I'm trying
to do.
How do I link the t_customer table to the combo box.
Any help would be greatly appreciated. Thank you.