Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Stock control..help please
Win98 & or Win XP
MS-Office...using XL I consider myself an Excel novice student with spreadsheets etc. and have the following problem I wish to seek help with for my son. I have tried to devise a workbook with a stock control system based on a given manufactured item GATES, which there are variants, some years ago but have no records of it now.! E.G. Gate1 is a standard sized item consisting of say 30 different components, and fixed amounts of each of the 30 different components, made up from stock. Gate 2 also a standard size item but of different dimensions from Gate1 above. This pattern carries on covering say 20 gate sizes, each one having a known amount of components. What I am trying to achieve is creating a stock control that would deduct the relative compnents of any given GATE, from my stock, by entering the GATE number as a reference point, using LOOKUP maybe? I find it difficult to put into words, but it may mean I have to purchase a suitable software application, but I thought I may be able to do it in Excel somehow?........anyone know of such inexpensive applications? TIA |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combination of stock chart and line chart | Charts and Charting in Excel | |||
Control Tab from Combo box- format control missing!! | Excel Discussion (Misc queries) | |||
Copying list-box control | Excel Discussion (Misc queries) | |||
Why is pointer and keyboard control is lost in certain Excel file. | Excel Discussion (Misc queries) | |||
Data Table - Does it work with DDE links and stock tickers? | Excel Discussion (Misc queries) |