I read through my last post and it made no sense at all. Its kinda har
to explain so let me try again.

Here is the part numbers we are running with the number we need t
run.

25752599 = 3
25747753 = 2
25747755 = 1
25752597 = 3
25747761 = 0
25747763 = 3
25752595 = 2
25747769 = 0
25747771 = 2
25752602 = 1
25747741 = 0
25747749 = 1

The part numbers are in cells A4:A15 and the quanity are in cell
B4:B15.

Now A16 = 12 meaning team one has to build 12 of these.
And A17 = 6 meaning team two has to build 6 of these.

What I was wondering is if I could write something that would separat
these giving team one 12 of the 18 (listed in cells C4:C15) and tea
two 6 of the 18 (listed in cells D4:D15).

But the numbers in B4:B15 can change quantities. As can A16 and A17.

I hope this is possible, it will save me a lot of time.

-TyeJae

--
Message posted from http://www.ExcelForum.com