VBA Help - Comparing Two Sheets in One Workbook

[Bigwelshal]

Hi.

I'm wondering if anybody could help me with this or if it is possible.

I have two worksheets of data, each row is the same case on both sheets and the columns all contain the same variables I just need to know the differences between each row.

I'm looking for a VBA that could compare the two sheets row by row and output a list row by row of which cells differ?

I have tried to hunt something down but all I can find is VBA that would highlight the different cells which wont do for this task.

Any help would be greatly appreciated.

Many thanks,

Alex.

 

[OaklandJim]

This SEEMS doable. But to do something for you I'd need some data. Consider installing the XL2BB addin which enables you to post "minisheets" which are portions of a worksheet. Find out about it here: XL2BB - Excel Range to BBCode