Populating spread sheet rows with Based on Pulldown Menu?

  • Thread starter Thread starter anderson115
  • Start date Start date
A

anderson115

I'm in need of some advice. Any feedback would be much appreciated!

I have two columns being utilized as selection criteria A1 and B1. The
same spreadsheet has columns with customer name. address, phone
number, and other summed totals. All this information is on sheet #1
in the workbook.

A1=WidgetName A2=Widget Price

I know how to populate a drop down menu.
For a specific selection combination of Widget Name and Widget Price
I'd like to populate columns B-M on a sheet #2 in the work book with
all the rows from sheet #1 where WidgetName and Price match.

Can someone direct me to an appropriate template (it needn't be free),
post a brief explanation or an appropriate search string to Google?

Thanks much for reading.
 
One way, illustrated in this sample at:
http://www.savefile.com/files/794372
Extract rows from other sht based on multi-criteria.xls

Source data assumed in Sheet1 cols A to E, from row2 down,
where col D = WidName, col E = WidPrice

In Sheet2,
The inputs for WidName & WidPrice are selectable DV items in A1 & A2

Put in B2:
=IF(OR(A$1="",A$2=""),"",IF(AND(A$1=Sheet1!D2,A$2=Sheet1!E2),ROW(),""))

Put in C2:
=IF(ROW(A1)>COUNT($B:$B),"",INDEX(Sheet1!A:A,SMALL($B:$B,ROW(A1))))
Copy C2 to G2. Select B2:G2, copy down to cover the max expected extent of
data in Sheet1, say down to G200. Hide away col B if desired. Cols C to G
will return the required results, ie the lines from Sheet1 satisfying the
inputs in A1:A2, all neatly bunched at the top.
 
One way, illustrated in this sample at:http://www.savefile.com/files/794372
Extract rows from other sht based on multi-criteria.xls

Source data assumed in Sheet1 cols A to E, from row2 down,
where col D = WidName, col E = WidPrice

In Sheet2,
The inputs for WidName & WidPrice are selectable DV items in A1 & A2

Put in B2:
=IF(OR(A$1="",A$2=""),"",IF(AND(A$1=Sheet1!D2,A$2=Sheet1!E2),ROW(),""))

Put in C2:
=IF(ROW(A1)>COUNT($B:$B),"",INDEX(Sheet1!A:A,SMALL($B:$B,ROW(A1))))
Copy C2 to G2. Select B2:G2, copy down to cover the max expected extent of
data in Sheet1, say down to G200. Hide away col B if desired. Cols C to G
will return the required results, ie the lines from Sheet1 satisfying the
inputs in A1:A2, all neatly bunched at the top.
Click to expand...

MAX- Thank you very for the thorough response and example. This helped
me prepare a workbook for our client. It was just what I needed!

Aaron
 
Back
Top