My friend Paris keeps a spreadsheet ("DATES") of men she
dates and how much they spent on her. Some names (like
mine) appear multiple times:

Paul 10.00
Paul 15.00
Larry 5,780.00
Jim 10,900.00
Paul 6.00
David 14,500.00
David 22,000.00


Now, on another sheet ("VIP")she keeps a list of dates
that have special privileges. Paris wants to extract from
the DATES sheet every row that a name matching a name in
the VIP sheet.

Any ideas?

Thanks
Paul
(I'll intro you if you help; the rest is up to you...)

This task is better suited for Access, one table "Dates"; one table
"VIP". Then doing a full join on the name field.

But in Excel, you could name ranges for "Date_Names" and "VIP_Names"
and loop through Date_Names and for each name loop through VIP_Names.
I'm sure there are better ways.

"Paul" wrote in message ...
My friend Paris keeps a spreadsheet ("DATES") of men she
dates and how much they spent on her. Some names (like
mine) appear multiple times:

Paul 10.00
Paul 15.00
Larry 5,780.00
Jim 10,900.00
Paul 6.00
David 14,500.00
David 22,000.00


Now, on another sheet ("VIP")she keeps a list of dates
that have special privileges. Paris wants to extract from
the DATES sheet every row that a name matching a name in
the VIP sheet.

Any ideas?

Thanks
Paul
(I'll intro you if you help; the rest is up to you...)

(Jake) wrote ...

This task is better suited for Access, one table "Dates"; one table
"VIP". Then doing a full join on the name field.

The OP may not have the MS Access app! Anyhow, Jet does all the work
with tables joins etc so the MS Access app wouldn't be required for
this. The OP could use the Jet provider to join the two Excel sheets
as if they were native Jet tables. Whatever, the join type required is
an INNER JOIN. I don't know what you mean by 'full join' because the
ANSI syntax FULL OUTER JOIN is not supported by Jet. Yours is a very
confusing post!

Jamie.

--