I'm not even sure if this is possible but I'm going to throw this one out
there and see what everyone has to say...

Item 1: I have data exported from a management system, imported into Excel.
Item 2: I have data exported from ACT 6.03, imported into Excel.

I need to create a report that looks at both worksheets, and then creates a
summary.

For example: I have a sales guy that goes to 5 shops within the week of
9/7/05 (Act Data). I then want to search or look up those 5 shops (CMS
data) and see what type of work/sales were generated that week of 9/7/05 by
that sales guy for those shops.

I have the data, I just need to find away to manipulate it. I've worked in
IT for 15 years so if you throw me a bone I might be able to run it.

Thanks CJ