Paris Hilton has an Excel question
 

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...)

Paris Hilton has an Excel question
 

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...)

Paris Hilton has an Excel question