This may... or may not be complicated for the programming professionals here on the site.

I pull sales pipeline reports off a tracking system into an excel file.
Over the course of the month they make changes to their pipeline and when I pull the new report I have to reconcile the changes. With over 1,200 entries into this system, as you can imagine it can be quite a difficult task!

The row looks something like this (this is only a small section as it has 23 columns of information!)

12 columns with the different months | Opportunity Record Type | Opportunity Owner | Sales Market | Opportunity Name | Type | Customer Name | Close Date | Created Date

THe challenge is the following:

1. The information is not in the same order as there are always new opportunties being placed in the system.
2. I need to use a few keys to ensure I am looking at the right records. I think I can safely use the following three headers in conjunction to distinguish the various records.
* Port
* Created Date
* Opportuntiy Name

There are three challenges I would love to tackle.

1. Create an easy to use master file.
2. Create a button on the master file to import the data from Sheet 2 in the first workbook and sheet 2 from the second workbook.
4. Create a button which would reconcile the two sheets and deliver a report which shows the following:
a. New accounts added
b. Changes to current records

I know this is a LOT to ask, but I would appreciate any help or direction you could give me.

Thank You!

Joe