+ Reply to Thread
Results 1 to 3 of 3

Creating a Parts list

  1. #1
    Registered User
    Join Date
    03-17-2018
    Location
    Berlin, Ct.
    MS-Off Ver
    10
    Posts
    1

    Creating a Parts list

    Hi everyone, I am new to the forum and this is my first question. I am creating a sheet that can figure the parts of a cabinet. The problem is I need to compile a list of the parts from several lists. The columns are Box, Width, Length, # of pieces. These columns are repeated three times for the back bottom and sides. The list needs to combine duplicates and collate from largest to smallest from all three lists. Thanks Thomas

  2. #2
    Valued Forum Contributor ranman256's Avatar
    Join Date
    07-29-2012
    Location
    Kentucky
    MS-Off Ver
    Excel 2003
    Posts
    1,011

    Re: Creating a Parts list

    youd have 1 Parts list.
    every unique part. no repeats.

    then youd have Composite part list. (composed from the Parts list above)
    [item], [part], Wd, Len, [Qty]
    Table1, 2x4 3ft, 4
    Table1, 4x4 1" board, 1
    Table1, 1/2" screws, 8

    etc..

  3. #3
    Forum Expert sandy666's Avatar
    Join Date
    02-05-2015
    Location
    Any Country
    MS-Off Ver
    farerwell
    Posts
    8,749

    Re: Creating a Parts list

    Hard to say something without sample excel workbook but one way is a PivotTable
    sandy
    How to create an editor for Power Query with Notepad++ (tutorial)
    How to create timeline project with vertical today marker (2010, 2013, 2016 etc...) (examples)
    Tips for Excellent Spreadsheets

    What makes learning so hard is the amount of knowledge you have to unlearn
    Why is my program not doing what I expect?
    Because you set the wrong expectations. Rewire your brain

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 08-23-2017, 07:29 PM
  2. Replies: 6
    Last Post: 05-01-2016, 04:41 AM
  3. [SOLVED] Creating a Parts List from an Equipment Database with checkboxes for each row
    By JoeyFinnz in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 03-04-2016, 01:32 PM
  4. Scan parts OUT to Sheet1, parts IN to Sheet2 and list in Sheet3
    By Nu2Java in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-12-2012, 11:40 AM
  5. creating a parts list
    By artj in forum Excel General
    Replies: 3
    Last Post: 07-29-2012, 06:42 PM
  6. [SOLVED] Finding the value from the list parts and insert extra part in the list
    By PRADEEPB270 in forum Excel General
    Replies: 3
    Last Post: 10-15-2010, 01:29 PM
  7. Creating a used parts list?
    By danjstock in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-17-2008, 10:14 AM

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