Compare multiple data points in row _ multiple sheets _ output different information

[floydian]

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

[floydian]

I have two sheets: One has old sales data and I have another with new data.
The updated sheet may (or may not) have additional information on it and some of the details of the sales may have changed.
The macro needs to see if the information on the second sheet (New Information) is already on the old sheet and if it is then it needs to check to see if any of the columns below have changed. If this is a new record (not on the old record) then it needs to be added.

Please don't ask why the information is in this order. This is the way it comes when we get I pull the report out of the system.

I hope you can help!

Here are the rows:
A June
B July
C August
D September
E October
F November
G December
H January
I February
J March
K Opportunity Record Type
L Opportunity Owner
M Sales Market
N Opportunity Name
O Type
P Customer Name
Q Close Date
R Created Date
S April
T May
U Annual Amount
V Annual Revenue
W Port ID
X Customer Record Type
Y Stage