TryinToGetPaid
05-03-2007 08:50:37
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?
CollidgeGraduit
05-03-2007 09:40:00
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.
TryinToGetPaid
05-03-2007 10:39:10
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.