Extract Data if Value is Greater Than Zero?

[MikeBaca]

I built an estimating spreadsheet for the electrical construction industry and am trying put together a "Materials List" on another worksheet. I want the materials list to display materials which have a value greater than zero.

Example, the 1st worksheet is my estimating worksheet which contains a list of 30 materials. The 2nd worksheet is a "Bill of Materials" that I would like to display in a proposal format to the customer. I only want to show them materials that have a quanitity of more than zero from the estimating worksheet.

Any help on this would be appreciated.

[NBVC]

To best describe or illustrate your problem you would be better off attaching a dummy workbook, the workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

If needed supply a before and after sheet in the workbook so the person helping you can see what you are trying to achieve.

Doing this will ensure you get the result you need!

[MikeBaca]

UPDATE:
I have attached a sample workbook. If you look at Tab 1 called "Estimator" you'll see some equipment. I have plugged in some sample values so they would populate on Tab 2 called "Bill of Materials". The problem is on Tab 2 I don't want there to be gaps in between the materials. I want them to start appearing in Row 5, then the next material in Row 6 and so forth.

[NBVC]

In Estimator!V10, enter: =IF(B10="","",COUNT(B$10:B10)) and copy down

In Bill of Materials!D1, enter: =MAX(Estimator!V:V)

in Bill of Materials!A5, enter: =IF(ROWS($A$5:$A5)>$D$1,"",INDEX(Estimator!B$10:B$40,MATCH(ROWS($A$5:$A5),Estimator!$V$10:$V$40,0)))

copy down and across the table...

... adjust ranges to suit and change to get appropriate info...(i found no description reference).

[MikeBaca]

NBVC -

The formula you gave me worked out great for the Quantity Column, however the "Part Number" and "Description" column did not work. Any suggestions?

[MikeBaca]

NBVC -

Sorry correction, only the description column is NOT working now.

[MikeBaca]

NBVC -

My mistake. As you posted previously you mentioned you did not find a reference for the "Description" Column which is actually column A of Estimator. I made the correction and everything is great now. THANKS FOR YOUR HELP!

[jasonminerbailey]

MikeBaca,

It looks like you are quite experienced with this type of request so wanted to see if you could be my savior. I have a very similar dilemma. For simplicity we can talk about the same sample sheet he provided. I am trying to do a similar task but would only want the "Bill of Materials" to pull the information that has a quantity of "1" or greater.

To breakdown further what I would like to do: I will list out every sample part (probably 500+ parts) on an estimating sheet and then my next sheet will act as a proposal for customers that will show the description from all items on the estimating sheet with the retail price. If an item has a "0" it would not show up on sheet 2 and there would not be a space between items that had a quantity less than 0.

[jeffreybrown]

Hi jasonminerbailey & Welcome to the Forum.

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.