Tom I thank you for the replies, but I cannot seem to get any of th
code working. The TM# is the variable number that is pulled down fro
a validated list I have. This variable number is the number that need
to match whatever is the corresponding customer. So if 1157 has 5
customers, thos 50 customers listed will populate a field/array/lis
something that i can work with, but it needs to be variable. So i
1157# changes to 0511 then the list changes and fills with that number
corresponding customers. If the comboxbox is avoidable thats better, i
not it will be fine. But all the code you posted I'm lost what goe
where, and where I need to change it to fit my needs.

The numbers and customers are listed in ascending order with customer
matching. i.e.

1157 sadsda
1157 fgfgvfv
1157 dsdsdc
1157 xzdsffv
0511 vbdfdf
0511 sddsffsd
0511 ujujyujy

These are also on a different worksheet. The variable TM# is cel
$B$4. This is the number that changes.

Jaso

--
jasda
-----------------------------------------------------------------------
jasda2's Profile: http://www.excelforum.com/member.php...fo&userid=2395
View this thread: http://www.excelforum.com/showthread.php?threadid=37580