Extracting Specific Data from one sheet to another.

[Pulling Data from one sheet to another.]

I have a sheet that has two columns. (Quantity and Description)
My description column has a list of all of the different possibile materials
that I could use for framing a building. So that list is very long....~1000
rows.

I need to set up a formula(or something) where I can enter in a Quantity
(for instance 25...meaning that I need 25 pieces of that Description) and the
quantity and description are both pulled onto a different worksheet.

That way I can go through the list of materials and enter in the Quantity
beside my description and I will only see the specific Descriptions that I
need on the other sheet and not the 1000 other pieces of data.

 

[Pete_UK]

One way you can do this is to just apply autofilter to the quantity
column after you have entered all the values - choose Non-blanks from
the filter pull-down (scroll to the bottom of the list), and it will
just show those descriptions which have quantities against them. You
can then highlight the visible data, and copy/paste to another sheet.

Hope this helps.

Pete