stock level teaser

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

You'll need a table to define which and how many parts are in which item.

Eg.

PartA Pin 2
PartA Cap 1
PartA Housing 1
PartB Pin 3
PartB Cap 2
PartB Housing 1
etc....

Code which checks out "PartA" can look in this table to find which parts
need to be reduced in your stock and by how much.
Presumably you stock info is in the same file...

Tim.


--
Tim Williams
Palo Alto, CA


"neilwebb" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>