find multiple criteria
 

i am toying with a couple of ways of doing this, and would like some input.

on one sheet, sheet1, i have data in columns a, b and c.

i want to compare every row on that sheet, with columns a, b and c on sheet2. it
may match column a or columns a and b, but if it doesn't match all 3 columns, i
need to add a row with the data from sheet1. if i matches all 3, then i just
have to add a value to another value in column d.

i was using find, i was creating a string with the data from sheet1, looping
through all of the rows on sheet2, creating a 2nd string and comparing it to
the 1st one.

just some input on the best way to handle this.


thanks
--


Gary

find multiple criteria
 

using a do loop can accomplish this, but it sure is slow.

--


Gary


"Gary Keramidas" <GKeramidasATmsn.com wrote in message
...
i am toying with a couple of ways of doing this, and would like some input.

on one sheet, sheet1, i have data in columns a, b and c.

i want to compare every row on that sheet, with columns a, b and c on sheet2.
it may match column a or columns a and b, but if it doesn't match all 3
columns, i need to add a row with the data from sheet1. if i matches all 3,
then i just have to add a value to another value in column d.

i was using find, i was creating a string with the data from sheet1, looping
through all of the rows on sheet2, creating a 2nd string and comparing it to
the 1st one.

just some input on the best way to handle this.


thanks
--


Gary