I have a small family business and need to be able to compare cells from
sheet1 to sheet2 via macro. Each worksheet has a different number of rows
and columns. Conditional formatting would be great but not allowed with
multiple sheets. "Range" seems appropriate but I'm not familiar with it. In
short of what I'm trying to accomplish, I need to highlight the cells from
sheet1 that matches the header from sheet2. Multiple results are expected
from each row/column on sheet1. Can you help? I would like all users to be
able to run a macro montly to validate data collected.
Hope you can help me. Thanks!