Excel 2007 : Comparing of an excel document with 2 w.sheets,creating a 3rd w.sheet with results

[macpegg]

Hi all,

I have no clue about scripts, I will need the solution in dummie terms or as close as possible :-)

I will be receiving reports on a monthly basis which each month i'll need to highlight the changes made between the new report against the old one a month ago. Both documents will be consistent with the same column titles.

I need to scan both work sheetrs, which has membership numbers, first/last name, address etc etc

Also.... for example each customer may have 2 to 8 accounts which i would like merging into one cell on sheet 3 (column 1).. currently these are on multiple lines..

Reason I need this, is that we are going the CRM route, which the project is taking 2 years.. In the interim i need create something where all customers are entered into Outlook as a contact.

I have already created a contact template and exported this, which i will need to then have the data from the report fed into.

Sorry i'm being a little vague, i have been out of my mind for the past week trying to find something.. When I read scripts on the net, it seems people describe what the script is doing or at least i think they are when entering text in the script which i have no clue if its part of the script or not..

Thanks for any help in advance.

Kind Regards

Darren

[arlu1201]

Please attach a sample workbook so we can understand the issue better.