Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Terry
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combination of stock chart and line chart hwatari Charts and Charting in Excel 2 September 24th 07 10:52 PM
Control Tab from Combo box- format control missing!! Mo Excel Discussion (Misc queries) 3 January 7th 05 02:09 PM
Copying list-box control Excel Discussion (Misc queries) 1 January 6th 05 02:39 AM
Why is pointer and keyboard control is lost in certain Excel file. MarkB3 Excel Discussion (Misc queries) 0 January 4th 05 08:15 PM
Data Table - Does it work with DDE links and stock tickers? Post Tenebras Lux Excel Discussion (Misc queries) 0 December 1st 04 06:15 PM


All times are GMT +1. The time now is 09:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"