Tansfering data to the proper locations after a go/enter button is selected.

[Spreadlover]

A quick overview of what this sheet does. It is meant to track a product we have shipped in that is unformed. We will call this product blanks. I need to enter what we received in on the blanks page in the quick load column. When the upload/enter button is pushed, (highlighted in red), the product needs to go to the selected column and set. Only the inventory on the Blanks sheet should be affected when the upload/enter button is pushed on this sheet.

The first sheet along with the gallon, quart and olive will track what has been formed and put into inventory. When the upload/enter button is pushed it will need to affect the selected product and change the inventory amount on these sheets. If the number is positive, it will need to add to the gallon, quart and olive sheets while it subtracts that same amount from the Blanks page. Now that the product has been formed, it will no longer exist as a blank, but it will exist as active formed inventory on the gallon, quart and olive sheets. Whenever a subtraction occurs on these sheets, it should only affect the formed inventory on the gallon, quart, and olive sheets.

On sheet one, there needs to be 5 upload/enter buttons. When pushed it needs to move the amount into the proper row and set of selected items. On the gallon, quart, and olive sheets there will be only one upload/enter button, but it will move any amount in column O.

Anytime an upload/enter button is pushed, I need a record of the transactions that occurred on the history page. The history page should just record straight down, just going to the next open row after every transaction. This way we can track who, what, and when the transaction occurred.

The formulas needed on this part of the worksheet are beyond my knowledge scope. I have an idea of what is needed, but I have no clue how to accomplish it.
Any help is appreciated.

[Spreadlover]

Bump, bump, bump.

[Spreadlover]

VBA CODE NEEDED

I would like to enter a total into the green highlighted (add/sub)(F3) column next to the command button. When the command button is pushed, (named upload)(G3) I need the total to go to the prospective sheet and product. After the code has run, I would like it if the cell F3 went back to the value of zero or blank cell. This will let the user know the amount entered was transferred to the total of the inventory.

When finished there will be several commands in this button, but for now I would like to work on them one at a time. This way I can learn how to write and combine them.

Any help is appreciated. I have been watching literally hour’s worth of vba tutoring, but I have been unable to come up with an example of anything close to what I am asking. Most of the tutorials are referencing message boxes or features I don’t need.

The above post will contain most of the finished details needed for this sheet to work for me. Without a way to add or subtract from the inventory totals, I will not be able to use this workbook.
Cup Inventory Sheet.xlsx

[Spreadlover]

I started taking this Workbook more piece by piece.

Here is a link to what should be the finished Workbook.

http://www.excelforum.com/excel-prog...alidation.html