Excel 2003 -
Hi all. I have a rather complex operation required and I'm wondering the best way to go about it. (Macros or existing functions)
Background.
We have lots of systems which hold contact detials (telephone system, LDAP, Peoplesoft etc) unfortunately they do not syncronise or they do but there are inconsistancies in the records.
All records have a common unique value which is the persons LDAP uid (username - textfield).
What I am doing is pulling all the data into a spreadsheet, a worksheet per system, and am looking for a way to link the records across the sheets to be able to compare the records.
Initially my first thought was to ensure that a uid is on the same row consistantly across the workbook by using some kind of a loop. Something like below (which doesn't work!)
Can anyone throw any ideas of how to go about this at me?
If you need anything clarified, I'd be happy to explain further.
Bookmarks