Review excel Sheet

[StuHart]

Please can anyone help, I'm trying to check data changes in excel and need to us VBA. I run a macro for the following. Starting with sheet 1 which is will hold the master data and will not change, the data will have 10 columns and >700 rows. On sheet 2 will be the new revision of sheet 1 data which will have changed, on sheet 3 will be the results, so if row 1 on sheet 2 = row 1 on sheet 1 then sheet 1 will appear in row 1 on sheet 3, now if there is an error in a cell I've changed the cell color to red, if the row is not the same I've moved it to the end and restarted the check. As you may have gathered the macro does not run as I would like, Is it possible to run this check in VBA, if so I would appreciate help in structuring the code as my VBA skills are limited. Many thanks in anticipation.

 

[shawnhet]

My suggestion is to post what you have for your macro as well as a description of what you want it to do.

However, please see below for something reasonably close to what you appear to be looking for. Perhaps, with some adjustments, you can make this work for you.

http://www.exceltip.com/st/Compare_two_worksheets_using_VBA_in_Microsoft_Excel/477.html

Cheers,

 

[StuHart]

My suggestion is to post what you have for your macro as well as a description of what you want it to do.

However, please see below for something reasonably close to what you appear to be looking for. Perhaps, with some adjustments, you can make this work for you.

http://www.exceltip.com/st/Compare_two_worksheets_using_VBA_in_Microsoft_Excel/477.html

Cheers,

thanks 4 that i will give it a go.