Match columns in two workbooks

**sibyxa** · 08-26-2009, 01:36 PM

Need a help below macro, when I run macro get an error

The code will go through each line of data checking to see if it can find a match. If not, the cells will be highlighted yellow. It checks from both sides, first checks sheet 1 compared to sheet 2, then sheet 2 compared to sheet 1. That should encompass the variations between the 2 sheets.

sample attached

Help will be appreciated

Thanks

**Leith Ross** · 08-26-2009, 01:45 PM

Hello sibyxa,

Your workbook is in Excel 2007, but your profile says you are using Excel 2003. Can you post a copy of the workbook in Excel 2003 format? You'll more an answer faster.

If you are using both 2007 and 2003, please update your profile. It helps to know which versions you are using when asking and answering questions.

**ravishankar** · 08-26-2009, 01:52 PM

HI
Attached file has a macro which matches sheet1 with sheet2 and vice versa
Ravi

**JBeaucaire** · 08-26-2009, 02:06 PM

Try this instead, a little more concise, I think:

Please Login or Register  to view this content.

**sibyxa** · 08-26-2009, 02:31 PM

Wow! It worked perfectly

Thank you Friends

Leith Ross, I have updated my profile, changed to 2007

Ravishankar, thanks for your great help

JBeaucaire, thanks for your great work

Once again, thanks for all the help provided

**sibyxa** · 08-26-2009, 02:34 PM

How can I change this to "Solved" ?

**Leith Ross** · 08-26-2009, 02:56 PM

Here is how to Mark your Post Solved:

How to mark a thread Solved
1. Go to the first post #1
2. Click Edit
3. Click Go Advanced
4. Just below the word Title you will see a drop down with (no prefix)
5. Change to [Solved]
6. Click Save