+ Reply to Thread
Results 1 to 1 of 1

Inventory Management sheet for lower level staff - needs improvement!

  1. #1
    Registered User
    Join Date
    09-23-2011
    Location
    Bangkok, Thailand
    MS-Off Ver
    Excel 2003
    Posts
    1

    Inventory Management sheet for lower level staff - needs improvement!

    I've tried to create an inventory management workbook for lower level staff to use. I will highlight below the current features and the features I need help with! Do let me know if you are able to provide any assistance. Thanks

    Current features:
    - Staff can click on each item which links to its respective sheet and click on the top left logo which takes it back to Home page
    - Staff enters the re-ordered amount (+) or used amount (-) in each item sheet
    - The first page is a summary page that links the current balance of each item
    - The first page automatically signals (in red) when an item needs to be re-ordered

    Need to have:
    - Easy way for staff to enter new items to the list themselves (without having knowledge of how to linking sheets on the main page)
    - Easier way to input re-ordered amount (+) or used amount (-) on one page instead of continuously linking to other pages
    - Prefer to have all this on one page. My gut is that we can use Pivottables. But I'm not sure how and if this is the best way
    Attached Files Attached Files

+ 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