query a spreadsheet
Well, if you're looking to do a query, the best thing to do would be to
import those two sheets into Access and run a query of the link of customer
names.
I.e., a select query from the customer address list, filtering for those
records which also appears in your registered customer list.
Another thing to try, which I've never done before, but I believe can be
done, is to use Excel's MS query tool to query those two data tables as
separate Excel workbooks.
--
Brevity is the soul of wit.
"sandy" wrote:
I have two spreadsheets. One is a complete list of our customer database and
the other is customers who registered for a conference. I'm looking for a
way to pull out from our excel list only the customers who registered so I
can do some mailouts to them.
|