Comparing two excel files macro

**Tirion** · 11-02-2010, 04:52 AM

Hey guys!

I have this task which is driving me crazy! I tried to ask Google and search through different forums, but I couldn't find much which could help me.

Now my task looks like this:
I have to compare two alike excel workbooks (each containing seven worksheets), with same formatting but slightly different content. One contains old data, and the other new data.
Now I need to compare every worksheet from the file with new data, with the one from workbook with old data. I just have to compare column B (starting with row 14) which is filled with strings. If the old sheet holds some elements which the new one doesn’t then the complete row from the old sheet should be added at the first empty row at the worksheet from the file with new data. And maybe even a little highlighted, but I guess that’s then not a big of a problem

And that’s it. I'm stuck after opening the two different files.

**blane245** · 11-02-2010, 03:10 PM

Welcome to the forum!

Here's a macro that might meet your needs. The old and file file names need to be updated to match the ones that you are using. I have highlighted the new rows in yellow.

Please Login or Register  to view this content.

**Tirion** · 11-04-2010, 05:20 AM

Wow, thanks pal!
This really helped! The code works perfect now.

Thanks again!

**vicabral** · 12-06-2010, 07:35 AM

hI,

i have the same situation here in my job, but I don't know a lot about macros, so I hope you can help me.
I updated the file's names and tried to run the macro, but it stops in this line:

Set oldBook = Workbooks.Open(oldFile)

what should I do in this case?
Do I need to change the file nema, or should I open the files to run this macro?

What am I doing wrong, please?

Thanks ! ! !

**blane245** · 12-06-2010, 08:46 AM

I would suggest that you start your own thread and more fully state the problem that you are having. You will notice in my original reply that you do need to set the name of the files to the one's you are using. Tirion, if if are though with this thread, please close it. See forum rules #9 for how to do this.