Compare columns across worksheets to ensure they match.

[CJPHX]

Good Afternoon all,
I currently have a macro that grabs some date form sheet 3 and pastes it onto sheet which feeds into a pivot table. The problem I am having is that if the worklists names get reorganized on one sheet the data is inaccurate when it is pasted over as the worklists names are not on the same rows. Is there a way to get the macro to check the columns to ensure the information is identical and showing an error message if not before continuing on.

For Example: Column A of sheet 1 has the alphabet
A
B
C
D

Column A of sheet 2 has the alphabet as well but it go out of order.
D
B
C
A

I would like the macro to check and make sure column A on both sheets has the same info in each row before copying whatever data I need.

[salimudheen]

Hi,
Below is the code for that:

Copy this code and paste in to one module.

And change the workbooks path.

Please Login or Register  to view this content.

Hope it will more help you!!!

Regards,