sheet contents comparison

[tweety127]

Hi Experts,

I'm currently doing some comparison study located on different sheets. I want to compare if the contents of column of the master sheet is also in the other 2 sheets. Is there a macro or a function that can ease up this task?...

Thanks!

[ashleykelley]

do you want to compare just the contents of one column or the whole sheet? and what are you trying to display if the data is found in the other worksheets? do you want to delete the data? display true/false, etc.