Combining Data from multiple sheets, plus tracking?

[mocp2008]

I'm learning so much as a member! Thanks everyone.

Here's my current question - I don't believe this is a difficult one, but what do I know?!

In Sheet1, I have ColA through ColH with data. In Sheet2, I have ColA through ColAA with data.

Now, I need to create a new sheet that combines the two based on values in ColC on both sheets. I upwards of 10K rows on each sheet.

I'll attach a (significantly shortened) example as a reply. I can't mess this one up - very important, lol.

Also, would there be an easy way to kick out a second sheet for at least sheet2 that adds a field with yes or no, to indicate if a match was found from Sheet1?

Any help!? Thanks!

[mocp2008]

Here's the example.

[mocp2008]

I just realized that it would probably be better to revise this a bit. Lets say that sheet2 has column A filled with "Yes" or "No"s. If, "No" then find the same on the other sheet, as described. The resulting page to kick out would then retain that same formatting, except anything that copied over would turn to "Yes" on the new sheet, and could be reused.

Does that make sense?

[mocp2008]

Anyone? I'd very much appreciate any ideas! Thanks.

[MatrixMan]

Here you go ...

Please Login or Register  to view this content.

Hope that helps.

[mocp2008]

Thanks for the reply. Unfortunately, I'm getting the following error:

Compile Error:
Invalid use of Me keyword

indicating an error on

Please Login or Register  to view this content.

[MatrixMan]

It's probably because you've moved the code to a module rather than leaving it embedded in the results sheet ... if you want to do this, then replace "me" with "Worksheets(strResultsSheet)" and you'll need to create a constant or variable for strResultsSheet = the name of the sheet you want the results to display ...