Building a parts list

**timeasterday** · 05-07-2013, 08:45 AM

I have a simple spreadsheet where someone can select parts from one sheet and I would like to build a parts list on another sheet of only the selected items.

So in the attached example, Sheet2 contains the master list of parts with pricing. What I would like is anything with a quantity of 1 or more (column A) would get copied over to the blank list on Sheet1. I suppose some VBA code could do this easily but I am not very knowledgeable at that stuff.

Thanks for any help!

-Tim

**Melvinrobb** · 05-07-2013, 10:07 AM

By adding a helper column, does the attached work?

**timeasterday** · 05-07-2013, 11:17 AM

That looks like it does just what I wanted. Thanks!! Now I need to go study those formulas so I understand it.

**Melvinrobb** · 05-07-2013, 11:35 AM

Glad it will work.

The INDEX and MATCH functions are quite useful. I would definitely do some research online.
Here is a breakdown of your formula:

Formula:

Please Login or Register  to view this content.

Blue = the actual data from the table
Green = your row headers (in this case the helper column that is only identifying rows with a value >0 in column B)
Red = Your column headers

Remember to change the thread to solved (under thread tools).