Re: Compare data in multiple columns across 2 worksheets
Quote from cytop;560259
Lawsonrw - please edit post #14 to include code tags. These are required by the rules here. If you need further information, please have a read on this link.
In post #14 I wrote:
It would be appreciated if you comply. You were already reminded of the rules with regard to thread titles yesterday and subsequently double posted (also against the rules).
In Post #14 I wrote
[INDENT]Followed your instructions, hit run, got "Run-time error '9': Subscript out of range" I even changed the "Sheet2" to TBP (the name of my second worksheet). [/INDENT]
If you by code tags you mean the reference to sheet 2 I'm guessing that would be:
Set found = Sheets("TBP").Range(nameCol).Find(cell, LookAt:=xlWhole) '''Sets a new range for each time the value from Sheet1 shows up in TBP sheet's Column C
For Each found In Sheets("TBP").Range(nameCol)
Otherwise the actual error message is a pop-up notification from Mircrosoft Visual Basic and I don't know what associated tags could accompany that string. As you can see since our last correspondence I have since tried to remain compliant, but on this matter I do not what exactly you are referring to.