HELP PLEASE

I have 3 items which are all made from the same parts. the only
difference is that part A has a different number of parts compared to
part B and part C.

for example - Part A has 2 pins, 1 cap and 1 house whereas Part B has 3
pins, 2 caps and 1 house.

i need a spreadsheet that distinguishes between a Part B being sold and
a Part A so that stock levels of pins, caps and housings are reduced
automatically.

many thanks

neil


--
neilwebb
------------------------------------------------------------------------
neilwebb's Profile: http://www.excelforum.com/member.php...o&userid=24450
View this thread: http://www.excelforum.com/showthread...hreadid=470760