I have a spread sheet that I have created to track the invantory of parts
that we put into kits. I update the spreadsheet the long way every time I
sell a kit. Is it posable to to make parts lists on either a seperate
"sheet" or on a seperate document that will have all of the parts that go
into these kits and their quantities so that I can just subtract a kit at a
time from the total invantory?

The short answer is yes. Getting there depends on what you are using for an
inventory data base and where you intend to build you bill of materials. If
you are using Excel for both, then the bill of materials would be treated as
a list. The inventory database would need to be constructed so that you
could use either a part number or stock number for matching. Things to
consider in constructing a loop to walk down the BOM and find items in the
inventory would be the number of locations in inventory, reserved quantities,
etc., But basically, it is as simble as using a For Each...Next loop to walk
the bill of material and a Find statement to locate the inventory record.
You would need either If...Then statements or Select Case statements to make
sure the BOM quantities can be substracted from available quantities. There
would be some math comparisons if you have reserved quantities, plus you
might be concerned with reorder activiity to replace inventory. It depends
on how much inventory management you want to build into it.

"extremecase_8" wrote:

> I have a spread sheet that I have created to track the invantory of parts
> that we put into kits. I update the spreadsheet the long way every time I
> sell a kit. Is it posable to to make parts lists on either a seperate
> "sheet" or on a seperate document that will have all of the parts that go
> into these kits and their quantities so that I can just subtract a kit at a
> time from the total invantory?