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


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

stock level teaser
 

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" wrote in
message ...

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