T
Tim hagedorn
I am currently using excel that tracks all of my incoming
items, inventory, production and sales. This is working
OK. I have a problem when I go to change the form (new
products or deleted products). I have to change the whole
workbook to ensure that cells haven't changed.
I know I can build and track my inventory in Access, but I
want to be able to put my sales and production in as
well. My goal is to be able to input production numbers
in everyday and have my inventory pull the appropiate
pieces (box, bags, labels) for that particular product. I
then want my "stock" of finished products to accumulate
based on my weekly numbers. I also want to input my sales
so my inventory of finished product also flucuates.
Can someone help me with how to set this up???
Thank you
Tim
..
items, inventory, production and sales. This is working
OK. I have a problem when I go to change the form (new
products or deleted products). I have to change the whole
workbook to ensure that cells haven't changed.
I know I can build and track my inventory in Access, but I
want to be able to put my sales and production in as
well. My goal is to be able to input production numbers
in everyday and have my inventory pull the appropiate
pieces (box, bags, labels) for that particular product. I
then want my "stock" of finished products to accumulate
based on my weekly numbers. I also want to input my sales
so my inventory of finished product also flucuates.
Can someone help me with how to set this up???
Thank you
Tim
..