VB Script search within a column in one Wb and find in another WB and Highlight yellow

Hi
I am looking for a way to search all text within each row within one column and find the exact match in another workbook and highlight that cell yellow.

is there an easy script that can run and complete this quickly. it would save me hours of work.

Maybe:

Please Login or Register  to view this content.

Sorry i fixed it.

I get an error still. "out of range"

Please Login or Register  to view this content.

Hi Dixie,

If your search column for the 2nd workbook is also similar as "A" then try this code.

If it's a fixed column, however a different one than you can amend "1" to whatever you'd like under "ImportWB"

Paste in a new module

Please Login or Register  to view this content.

If you want to search the entire sheet with all the columns then you can use John's Code.

Just try removing

Please Login or Register  to view this content.

Jayesh25

your code runs without error, but I still don't see the code highlighting the cells yellow when it finds a match. Just to clarify, in column A1:A500 i have tag names in the missing PI tags workbook. I want to search for those tags in the DB workbook in Column A1:A50000 and highlight the cells yellow when found.

Thanks for you guy's quick response. Very much appreciated

DixieDiver,

I had set the workbook names the other way around. Retry the below code? I've changed the route from Missing Tags > DB now

Please Login or Register  to view this content.

Awesome that worked great
Thank you thank you thank you

Most welcome

Just thought of an enhancement for this code that would be helpful. using the code above how would I also highlight the tags that could not be found Red in the original document "Missing PI Tags 20141021b.xlsx"

Hi Dixie.

I've made some modifications. Try this?

Please Login or Register  to view this content.

Worked like champ, just had to change the second if found it =1 to 0

Thanks again