Populating spread sheet rows with Based on Pulldown Menu?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

anderson115@gmail.com - 08 Jun 2007 21:28 GMT

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.

Reply to this Message

Max - 09 Jun 2007 15:36 GMT

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.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> I'm in need of some advice. Any feedback would be much appreciated!
>
[quoted text clipped - 14 lines]
>
> Thanks much for reading.

Reply to this Message

anderson115@gmail.com - 15 Jun 2007 00:14 GMT

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

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

Reply to this Message

Max - 17 Jun 2007 14:53 GMT

You're welcome, Aaron
Good to hear that.

Signature

Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

> 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

Reply to this Message