I have two tables, which is to generate a form.

- The first table has 8 different cost centers.
- The second table have a list of task numbers, and the linked cos
centres.

Each cost centre has a set of task numbers, but there is just one cos
center for each task.

I want to first pick a cost centre from a combo box. I then want th
task numbers in the second combo box to be unique for that cos
centre.

How can I do this? By a macro

--
Ctec

-----------------------------------------------------------------------
Ctech's Profile: http://www.excelforum.com/member.php...fo&userid=2774
View this thread: http://www.excelforum.com/showthread.php?threadid=52351