untitled_1
New Member
- Joined
- May 8, 2015
- Messages
- 28
Hi I'm looking for a bit of help if possible.
I've got two sheets that are a bit similar. Sheet 1 contains a list of cars, with column F containing a concatenation of certain key fields in that particular row (Make-Model-Country).
Sheet 2 contains a similar list of information and again column F contains the same concatenation, however, other details such as the Colour and Year may be different to sheet 1 (see an example below).
I'm looking for something that firstly does an INDEX MATCH type lookup (between the concatenation in sheet 1 to sheet 2) and then highlight any differences it finds in columns D and E (Colour and Year) on sheet 2 (i.e. if it finds the concatenation but there is blue car with the same concatenation in sheet 1 highlight the new colour in blue). I only want the cells that are different on sheet 2 (to sheet 1) to be highlighted.
Sheet 1 can have up to 10,000 rows and sheet 2 has around 1,000 rows so the rows will not be in the same order on both sheets. I've tried highlighted the differences using conditional formatting and then using a macro to remove the rules (whilst keeping the formatting) but it takes far too long due to run so hoping there is a quicker way.
Is there a macro or VB that could highlight these differences in blue between the two sheets? I'd appreciate any help
I've got two sheets that are a bit similar. Sheet 1 contains a list of cars, with column F containing a concatenation of certain key fields in that particular row (Make-Model-Country).
Sheet 2 contains a similar list of information and again column F contains the same concatenation, however, other details such as the Colour and Year may be different to sheet 1 (see an example below).
I'm looking for something that firstly does an INDEX MATCH type lookup (between the concatenation in sheet 1 to sheet 2) and then highlight any differences it finds in columns D and E (Colour and Year) on sheet 2 (i.e. if it finds the concatenation but there is blue car with the same concatenation in sheet 1 highlight the new colour in blue). I only want the cells that are different on sheet 2 (to sheet 1) to be highlighted.
Sheet 1 can have up to 10,000 rows and sheet 2 has around 1,000 rows so the rows will not be in the same order on both sheets. I've tried highlighted the differences using conditional formatting and then using a macro to remove the rules (whilst keeping the formatting) but it takes far too long due to run so hoping there is a quicker way.
Is there a macro or VB that could highlight these differences in blue between the two sheets? I'd appreciate any help
Last edited: