+ Reply to Thread
Results 1 to 3 of 3

Stock Control

  1. #1
    Registered User
    Join Date
    04-02-2013
    Location
    christchurch, NZ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Stock Control

    Hi All,

    i need some advice with regards to formulas, i work for a traffic management company installing signs and cones and need to keep a check on stock. i am hoping someone could help me with formulas.

    i need to have a total column (for yard) then able to deduct for each site. After completion i need to recheck back in to yard... if that make sense, just a basic in and out.




    Regards,

    keith

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Stock Control

    Hi Keith

    I've attached a sample spreadsheet to get you started.

    I find that it is always best to go for overkill.

    Assume that the sheet will be used for stock control and also for ordering etc.

    That way you will not need to keep adding to it.

    Once you are happy with the layout, ask for help in the forum to create userforms to move stock around, close sites etc.

    Enjoy
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    04-02-2013
    Location
    christchurch, NZ
    MS-Off Ver
    Excel 2010
    Posts
    2

    Re: Stock Control

    thats great, many thanks for your help....

+ 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