.Find Method results issue...

[yellephant]

I'm trying to use the Find method to collect data from multiple sheets into one sheet, in a table. Right now, the macro I've written attempts to check cell row headings on individual sheets with the list of all possible row headings on the main sheet, and then correctly inserts the corresponding entry from the individual sheet into its spot on the main sheet.

However, I'm having issues with row headings like BBB+, BB+, and BB. Those are all possible row headings, but when I run the Find method, BB+ and BB are listed as matches to BBB+, and their corresponding entries are written over one another in the wrong row. I tried setting MatchCase to True, but it doesn't seem to account for this problem.

Is there a way to get Find to match BB+ with BB+ and BB with BB instead of both with BBB+?

[royUK]

Try setting Lookat to xlWhole

[yellephant]

Ah, there we go. That's much better. Thanks!

[royUK]

no problem