Thread: inventory programming help

excel 2010 inventory program?

I want to generate a sheet for inventory on excel 2010.

part1:
At the top of the program you enter the box number, name, quantity(either added or subtracted), and location into some sort of input box or line of cells or something. There is four different locations the boxes could be. Then the entered data is put into a table based on the location. Each table will have everything inside that location so four tables in all. Once the information is entered it will either update the quantity if it is already in the table else it adds the data into a new row.

part2:
Once the quantity reaches 0 it will enter the box and box number into a fifth table for reordering and erase the row from the table


any help with any of the coding part or if you could head me in the right direction will be much appreciated

Hello ncarrocino,

By the sounds of it creating a userform to enter the data into then have that distribute to the tables might be a good route for you. Since you gave very vague details I doubt anyone will be able to give you exact code. Perhaps if you were to submit a sample worksheet with before and after explaining exactly what you want to have happen we will be able to assist you better.

yeah i heard something about a userform but dont really know anything about it. Its a very simple program so i dont think it will be too hard just wanted to be pointed in the right direction.

Once you input the box number, name, quantity, and location it should use the location to determine what table to put the box and box number into. If its already in that table i just want it to update the quantity. like if i say "Pipes" "VPN456" "trailor 1" "+2" then it will add "Pipes" "VPN456" "2" to a new row in the table for everything in trailor1. If its already in there it doesnt add a new line only adds the 2 to the quantity. Or If i put "-2" it should subtract two from the quantity.

this way as i take boxes in or out i can just put it into the userform and have the table updated. What function would i need to use to determine if "pipes" is already in the table and to just update the quantity and if not it would add the row with pipes and etc. Do i need a looped if or is there a better way to do it?