VBA to check difference between 2 sheets

[kenadams378]

Hi,

I'm trying to run a check of 2 sets of data and pull out the differences between my current & prior tabs.

Basically i need to check the current tab against the prior tab and any diffferences add them to the New tab.

Any ideas?

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[kenadams378]

Brilliant, many thanks

[JOHN H. DAVIS]

You're welcome. Glad to help out and thanks for the feedback.

[kenadams378]

Thanks John, when i've used this code, it seems that it's copying over a loads of lines it doesn't need to onto the new codes tab.