| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using Excel to capture Inventory
Has anyone used excel as an inventory tracking tool? I've set one up and
every time something comes out of inventory in a given month, just add an additional plus to the formula on that line item. I've set up a reorder number and an if statement when a number drops below a certain number, it alerts me to reorder. However, a few items need removal from multiple places and people forget to note it in all, thus throwing off my numbers incredibly. ie.: 20 manuals ship means deduct 20 binders, 20 sets of tabs, 20 tapes. Someone can easily forget to deduct the tabs and I'm in a crunch. Any suggestions? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel filter won't capture everything in the column - why? | Excel Worksheet Functions | |||
| Scheduled data capture in Excel | Excel Worksheet Functions | |||
| Excel screen capture to capture cells and row and column headings | Excel Discussion (Misc queries) | |||
| EXcel Capture Data into one cell | Excel Worksheet Functions | |||
| How can i get an inventory list that adds and subtracts inventory | Excel Discussion (Misc queries) | |||
Threaded Mode
