Can I select multiple rows from a data range?

[Warrick Wilson]

I'm trying to add a feature to someone's Excel spreadsheet where they can
print a list of owned items based on a user id. In "real life", I'd be
looking at a database to do this, but it's a non-profit organization staffed
by volunteers, so you take what you get as far as technology goes.

In this case, there's a table (range) of Items and a table (range) of Users.
Each Item has a unique ItemID; each user has a unique UserID. Each item has
only one associated user; users obviously may have zero or more items at any
point. And that relationship is tracked by a (ItemID, UserID) relationship
where the OwnerUserID is a column in the Item data range. (hope that's clear
enough)

The updating of the user/item relationship isn't a problem (at least, it's
not my problem). However, what would be "nice" is to have a report/form
where someone can enter a userid in a cell, and the user information is
retrieved into an area, and the list of owned items is retrieved into a
"table-like" area.

I have the user info retrieval working, since it's just a basic one row
lookup. But the other part - getting all rows where the "OwnerUserID =
<idEnteredByOperator>" - eludes me. I keep thinking "SELECT * FROM ... WHERE
OwnerUserID=xx", but I don't know how to express that in Excel.

Is it even possible?

Thanks.

 

[Don Guillett]

A cursory look suggests that
data>filter>autofilter
should do what you need. Record a macro while doing manually. Modify to suit
an input box or range.

 

[Warrick Wilson]

A cursory look suggests that
data>filter>autofilter
should do what you need. Record a macro while doing manually. Modify to
suit an input box or range.

Thanks, Don. That got me looking at a whole section I'd not explored. The
Advanced Filter appears to have some features that may help me even more.
Plus I found a pile of info via Goog .. uh, Windows Live Search on using
that, plus automation examples. More fun to be had now...

Thanks again...

Warrick

 

[Don Guillett]

Glad to help