I have searched over the net and on this site but none fits my needs. I have datebase on inventory consisting of several tabs, what i want to do is have a macro to find a match and highlight the active cell if a match is found on different sheets. Only the active cell will be highlighted if...