I have 2 spreadsheets, and I need to run them against eachother.
Two Sheets lets call them X and Y. I need X to be run against Y and if they name appears on both X and Y - I need it to tell me or highlight it or something. Can this be done, or rather, how do I do this?
Is the information on it confidential? (It may help if I can see it and try a couple of things)
Are the two sheets in the same workbook?
It can definitely be done with some formulas and conditional formatting.
Well yes and no, nothing you could do anything with.
And no they are on two spreadsheets, but I can easily make them on one. It is just names of people.