B
Bill Postlewait
Hello everyone,
I thought I was doing pretty well in Excel, but after
reading a few pages of posts I can see that I have a lot
to learn.
I have developed a workbook to do job estimating and job
costing. Next step is to add inventory tracking.
I use a form I've created to do job costs which uses
Drop-down boxes in column "A" to get part numbers from
the database, and enter quantity used in
column "B".
In my parts database, column "A" has part numbers, and
cloumn "H" will contain inventory quantities.
I'd like to update the inventory by subtracting the
quantities used on the job cost form from existing
quantities in the inventory column.
Any ideas?
Thanks, Bill
I thought I was doing pretty well in Excel, but after
reading a few pages of posts I can see that I have a lot
to learn.
I have developed a workbook to do job estimating and job
costing. Next step is to add inventory tracking.
I use a form I've created to do job costs which uses
Drop-down boxes in column "A" to get part numbers from
the database, and enter quantity used in
column "B".
In my parts database, column "A" has part numbers, and
cloumn "H" will contain inventory quantities.
I'd like to update the inventory by subtracting the
quantities used on the job cost form from existing
quantities in the inventory column.
Any ideas?
Thanks, Bill