+ Reply to Thread
Results 1 to 2 of 2

Stock control..help please

  1. #1
    Terry
    Guest

    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



  2. #2
    Forum Contributor
    Join Date
    04-30-2004
    Posts
    122
    There is no easy answer to this question (ie. I can't write one line to fix all of your problems). However, I believe this would be fairly easy to do with a little knowledge of Excel and VBA.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1