Printable View
Sometimes the cheapest solution isn't obvious. Have your company hire either a consultant to do this one project, or a programmer to do all your programming. In your field, writing a bad program can sometimes cost more than is apparent until the bad stuff hits the fan.Quote:
Originally Posted by malley
Moved.
Bruce, regarding this code you wrote for me, if i want to check cell A2, A3, A4, etc against a set of data (instead of just A1), would I have to copy the code 3 times and change the reference to A1 to the relevent cell in column A?
I just stumbled across this thread; hopefully, you don't mind my chiming in.
Regarding cells A2, A3, and A4: One thing that you could try is, once a match has been found for cell A1, to then compare cell A2 to the cell immediately below the matching cell AND compare cell A3 to the cell which is 2 cells below the original matching cell, etc.
That way you only have to run the whole search thing once (for cell A1) and then check the other 3 cells for matches whenever you have a match for cell A1.
For instance, if cell C43 matched cell A1, then compare A2 to C44, A3 to C45, and A4 to C46. If all 4 match then you have a successful "total match".