copy data from sheet1 based on criteria in sheet2 to sheet3
Wouldn't using autofilter solve your problem? Overkill
would be using a listbox to select a given buyer # and
then have a macro copy their order onto a page 3 - but
this does not sound necessary.
John
-----Original Message-----
Sheet1 contains the results of an odbc query that looks
at an informix d/b and lists all of our buyers.
Sheet2 contains the results of an odbc query that looks
at an informix d/b and lists all of our "past due purchase
orders"
What I would like to do, is email a sheet to each buyer
of their Purchase Orders. I have a macro that emails the
current sheet. The problem is that I don't know how to
get each buyer's list of purchase orders on a separate
sheet.
I'm assuming that I must first list all buyers, search
for their Purchase Orders, copy that list to a new sheet,
then email the results. The list of Buyers and Purchase
orders would change each time I run the macro.
Hopefully, I've clarified myself.
Thanks.
Fred
.
|