I have a list of Territorial managers id's that are listed using simple
data validation. But when they pick their number from the validated
cell I need a combo box populated with only the customers that
territory manager has. I have data with over 2000 customers linked to
about 60 different TM#'s to select from so the cell needs to populate
and update automatically when new data is entered into the data sheet.
The data is on the "Data" sheet and the workbook is on sheet "Day".

This data need to fill 25 combo boxes (all with the same information,
even duplicates in each combo box) each in a different row. (We are
keeping a record of the Territorial manager's traveling for each
customer they meet with in a single month). The max amount of customers
they can visit is no more than 25, so if they actually met with 25
customers each customer is known.

I have a formula for variable strings that i posted earlier today, but
I found out that simple data validation in the excel cell can't handle
the excessive amount of data, and I receive 1004 runtime errors and
then sometimes it won't populate all the data into the cell, and cutoff
letters of customer's names.

Any solutions are welcomed, I am at the point where I am going to be
working on this project forever. thanks for any help

Jason


--
jasda2
------------------------------------------------------------------------
jasda2's Profile: http://www.excelforum.com/member.php...o&userid=23956
View this thread: http://www.excelforum.com/showthread...hreadid=375804