Adjusting stock data on stock usage spreadsheet

[RichardY1]

Hello All

I am trying to automate a task that is completed every day on a spreadsheet. I have an inventory tab, which contains the stock details of some 1200 different products. Each day we consume some of these products and update the inventory sheet using the find function and manually compute the new stock level.

Each day we also enter the details of usage (number of units) where the tonnage is calculated. I want to try to use the details we enter daily to calculate the tonnage used to adjust the inventory count.

The inventory sheet is arranged by locations in several columns as we also use this for a map to locate the items for a monthly stock count.

I basically want to enter usage details on a usage sheet next to the unique code used to identify the product, press a button and the stock level of the product on the inventory to be adjusted.

thanks in advance!

Rich

 

[RichardY1]

Anyone any ideas??

 

[DanteAmor]

Anyone any ideas??

Please Note
-----------------------
One thing you must keep in mind when you ask a question in a forum... the people you are asking to help you know absolutely nothing about your data, absolutely nothing about how it is laid out in the workbook, absolutely nothing about what you want done with it and absolutely nothing about how whatever it is you want done is to be presented back to you as a result... you must be very specific about describing each of these areas, in detail, and you should not assume that we will be able to "figure it out" on our own. Remember, you are asking us for help... so help us to be able to help you by providing the information we need to do so, even if that information seems "obvious" to you (remember, it is only obvious to you because of your familiarity with your data, its layout and the overall objective for it).