Hi there, i have 2 sheets, say named a and b, sheet a contains data extracted of the internet. Is it possible for me to program sheet b to search for any data which is already typed out in sheet b in column b which is in sheet a and if it is not present to say it is so. The data in sheets a is not organised in any particular column and that is what is giving me problems so far.

This program also needs to be shared with others so i cannot do it manually unfortunatly.

Thanks for any help.