Was wondering if this Macro could be adopted to work accrossed 3 column on 3 seprate sheet

[meabrams]

In looking through resent post I came a crossed this macro that I am wondering if it can be adopted to return what I need it to. Basically I have a macro currently that searches for match and it seems to run ok and return what I need it to but as the data lines grow I fear that it is going to take longer and longer to run.

My current macro to look a crossed 3 different sheets and return only the number that do not show up on one or the other secondary list (there is a possibility that it could show up on both secondary lists)

Please Login or Register  to view this content.

The code I was wondering if it could be moded to do what I need

Please Login or Register  to view this content.

originally found on
http://www.excelforum.com/excel-prog...ml#post4248495

posted by sktneer

Thank you for your help

[AlphaFrog]

This should be fast.

Please Login or Register  to view this content.

[meabrams]

Thank you this has shaved down the time for my macros to run and show only the I need it to. Will this work if its a combination of letters and numbers in the columns that it looks in? I currently have all letters converting over to numbers in the columns that are looked in so it would be an elimination of unneeded macro running

Example: A1234
12345
B2I32

[AlphaFrog]

Yes it will work for letters and numbers.

Add this one line for it to be case insensitive when comparing e.g.; A1234 will match a1234.

Please Login or Register  to view this content.

[meabrams]

Work Perfectly Thank You