You should be able to consolidate this information within PeopleSoft itselft
using the query function. This function also has a feature to eliminate
duplicates. I don't believe you need to bring the data into excel at all.

" wrote:

The system we are running is Poeple Soft. I know it is possible to get
this done through the People Soft functionality but we are not fully
implemented at this time. People Soft has a query function in which
you can run the query directly into an Excel spreadsheet. So for this
example I have three seperate spreadsheets with data. It is possible
to run nVision reports, however as I said we are not fully impelemnted
at this time.

Let me know if you have any other questions and thanks for your help!
Gerald