Excel Help

Den1se

Hi - hope somebody can help...this is driving me mad.

I need to compare the details in 2 worksheets in the same book & the differences highlighted. Each sheet has 4 columns (identical in both sheets) I need to be able to compare that the content of cells A1 - C1 in sheet 1 match the corresponding cells in sheet 2. In sheet 2 I need it to highlight any that do not match & also any items that appear in book 2 but not book 1 (hope that makes sense). Basically every month the contents of book 2 will move to book 1 & a new set of contents entered into book 2....I just need a really quick way to see the differences.....any ideas welcome

Thank you in advance

Owain_Moneysaver

I suggest using Conditional Formatting as described in the second part here. You'll need to put in the worksheet reference in the =NOT statement.

Den1se

Owain_Moneysaver wrote: »

I suggest using Conditional Formatting as described in the second part here. You'll need to put in the worksheet reference in the =NOT statement.

Thank you - I just can't quite get it to do what I need

FrugalFriend

Have you considered using a database instead? What you're describing sounds more like a job for a database application, such as OpenOffice/LibreOffice Base or Access.

A database makes sorting, filtering and comparing data easy. You could create a simple data input form. Then generate reports based on queries, such as comparing one set of data with another.

More4me

here is another suggestion, assuming you are comapring Sheet1!A1 with Sheet2!A1 only and likewise with other cells, then EXACT function will do the job, you have data in column A to D in both worksheets, so in cell E1 in Sheet2 enter formula =EXACT((A1,Sheet1!A1) this will return TRUE if both cells value is exactly same or FALSE if they are not equal. You can use conditional format on cell E1 to highlight FALSE value with colour to easily highlight the mismatch.
also any items that appear in book 2 but not book 1, not clear if you want to match cell A1 to Cell A1 in both sheets, as above, or Cell A1 in Sheet1 and Row 1 in sheet2", if later then experiment with Vlookup function.

Regards