Hello all, I posted this in another section but was told because I am looking for more of a macro or VBA style command I should post here.

Here is what I have,
A basic spreadsheet with an inventory list of parts and their respective quantities, it has some basic functions, but all those functions are manually entered. (example) when a part comes in, you must manually search for it, then go to the quantity column and add in the amount received, then you have to change the date of receive to that days date, then you select a from a drop down list that it has been inventoried (It changes the whole rows color based on the amount on hand vs amount required for current jobs). This leads to problems when you have 100s of parts with very similar names or when you are entering hundreds of parts in at one time (which happens a lot).

What I would like to have

At the top of the sheet I would have an Inventory In button, click on it and a search menu appears, using our barcode scan software to automatically enter the part number in the box it would search for that part in the list, once found it would change the box to ask how much inventory has been received, again you could manually enter or scan the code for amount into the box, it would then change the total inventory number to reflect the input, it would change the line from ordered to inventoried, it would erase all information in the amount order box for that part, and it would change the last date received box to that days date.


I know this is probably asking a lot but I would love to learn how to do this. Any help is greatly appreciated