Hello All,
I have asked our IT department to make significant changes to our current Sales Rep / Sales Manager hierarchy. Needless to say our current hierarchy is completely unable!
On the attached, I have two spreadsheets (one is called "Correct" and the other is called "Actual"). I need help coming up with a systematic way to compare the values on the "Correct" sheet to those on the "Actual" sheet. And then I need to relay those issues to our IT department to make the necessary changes.
Any ideas on how I can create this comparison without much manual work? I see situations where a person is listed as a Sales Manager and a Sales Rep, where Sales Reps are listed under incorrect Sales Managers, etc.
Thanks!
Andrew
Bookmarks