Most of your problem appears to be an organizational one. Once your data is
organized you can use sumif and countif functions depending on the results
you are looking for.



"CJ" wrote:

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