Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
from inventory to reduce stock record
I have a basic stock order form with several items on it. How do I link it to master inventory on another sheet so that every time stock is taken it will automatically reduce. Appreciate as a novice I need to learn certain fuctions. Can anyone just get me started with where to look and the appropriate functions? -- kinsey |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
from inventory to reduce stock record
Kinsey
A function or formula is not going to do what you want, you will need VBA programming. To get help with this you need to furnish some information about the layout of your data, both the order form and the inventory sheet. For the order form, specify the range that will hold the item names or part numbers or whatever you use to identify an item. Do the same for the quantities. In the Master Inventory, do the same for the ID and quantities ranges there. Finally, you will need a trigger (something you do) that will tell Excel that the order form is complete and is a valid order form for Excel to act on. Perhaps the action of printing the order form, or maybe you would prefer to have a button next to the order form that you can click on when the order form is complete. HTH Otto "kinsey" wrote in message ... I have a basic stock order form with several items on it. How do I link it to master inventory on another sheet so that every time stock is taken it will automatically reduce. Appreciate as a novice I need to learn certain fuctions. Can anyone just get me started with where to look and the appropriate functions? -- kinsey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inventory/Stock book | New Users to Excel | |||
INVENTORY STOCK COUNT | Excel Worksheet Functions | |||
Stock Inventory | New Users to Excel | |||
Inventory sheet to track, order & reduce quantity from master. | New Users to Excel | |||
Make inventory sheet to track, order & reduce quantity from master | Excel Worksheet Functions |