Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Inventory Workbook - automated entry worksheet???
I am curious is this is possible:
I have a workbook that I use for keeping track of inventory. Each worksheet is for a different department, and the inventory for that department is contained in that worksheet. The worksheets are simple. Each contains 4 columns: Part Number, Description, Quantity, and Location. Each worksheet's data is sorted descending by part number. I want to know if I can create a worksheet at the beginning of this workbook that would allow me to enter data, hit a button, and have it stored on the correct worksheet and have the data resorted. I would like to do this to save time sorting through worksheets and resorting data. Thank you. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"What-if" formula for either a manual entry and automated entry | Excel Discussion (Misc queries) | |||
Excel 2007/2003 - Automated value entry | Excel Discussion (Misc queries) | |||
Negative Entry to calculate remaining inventory | Excel Discussion (Misc queries) | |||
CollegestudentHelp me create an automated data entry program in Ex | Excel Discussion (Misc queries) | |||
CollegestudentHelp me create an automated data entry program in Ex | Excel Discussion (Misc queries) |