Extracting Specific 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.

Extracting Specific Data from one sheet to another.
 

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

On Jul 14, 10:32*pm, Pulling Data from one sheet to another. <Pulling
Data from one sheet to wrote:
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.