+ Reply to Thread
Results 1 to 5 of 5

Creating a used parts list?

  1. #1
    Registered User
    Join Date
    06-17-2008
    Posts
    16

    Creating a used parts list?

    Hi all,

    I am currently building a spreadsheet at work and would like to know if a certain function is available.

    I have a number of colmns such as product description, part no, quantity, net cost etc... The user has to enter the quantity and the spreadsheet calculates a total cost for that item.

    I would like to set up a second sheet that will automatically build a parts list when the user enters a quantity. Is this possible? I would like the parts list to reference back to certain cells such as part number and cost.

    My Office currently has to print out the whole list regardless of whether or not an item is being used which I feel is a big waste.

    I hope I have explained myself clearly and I would be very grateful if anyone could advise me about how to set up this formula.

  2. #2
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,202
    You could use VLOOKUP

    http://www.excel-it.com/excel_functions.htm
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example

  3. #3
    Registered User
    Join Date
    06-17-2008
    Posts
    16
    Thanks for the tip but its not quite what I am trying to do.

    I would like to have a second sheet that will build up a list of part numbers and quantities automatically if a quantity is entered in the correct row of the front sheet. This will then autofill a table with part numbers

  4. #4
    Registered User
    Join Date
    03-18-2005
    Posts
    5
    Sounds like a good use for Auto Filter. Go to Data|Filter and select Auto Filter. All of the columns should then have an Arrow on the top Row of Data. Select the arrow in the Qty field and Select "Custom". Then set that up to values greater than 0. It will then hide all of the rows that have 0 in the quantity field.
    You can then either copy the remaining cells to another sheet or select the remaining cells and use "Print Selection".

  5. #5
    Registered User
    Join Date
    06-17-2008
    Posts
    16
    That does look like it does the exact thing I want! I just don't have the ability to set it up properly.

    Thanks for the 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