Macro to match 2 sets of data cell by cell

[kenadams378]

Morning,

I have 2 sets of data in seperate sheets, i need to create a macro to check the data is the same in both sheets and any data that doesn't match to highlight the data. I have attached the sample data.

I need the macro to;

- Use 'Stock' column to identify the data
- Run a check on the data across both files and ensure each case contains the same data like for like.
- Create a summary of rows checked & number of rows on the data
- Create a new sheet of cases that don't match and highlight the cells of data that haven't matched.

Is anybody able to help on this at all or give me some pointers?

Thanks in advance

[kenadams378]

'bump - no repsonse'

[arlu1201]

How do we handle this? -

Run a check on the data across both files and ensure each case contains the same data like for like.

After stock column is checked in both files, which are the other columns to be checked? Both the data sets have different kind of info other than the stock column.

[kenadams378]

The column headers in row 1 are all the same across both spreadsheets.

[kenadams378]

bump - no response

[kenadams378]

Is anyone able to advise on this at all, is it possible?

[arlu1201]

The column headers in row 1 are all the same across both spreadsheets.

The headers in both the files that you attached are different from each other.

[kenadams378]

They are in a different order but the header text will be the same across both files in row 1

[kenadams378]

Do you need the column headers to be in the same order?

[arlu1201]

If that can be done, it will make the copy paste very easy.

Even if the order is not the same, the macro can be created but it will be a lil longer one, since we have to copy column by column.