Multi Year Data Comparison

Hi all,

I am currently comparing data spanning years which i've input into a single sheet and wondered if there is a method of coding to automatically detect changes ? (i.e if one year someone spend 10 on apples and 5 on oranges but the next year spends 3 on apples and 5 on oranges and 3 on bananas is there a way to highlight this? / Show?

Thanks,

Annoyingly it doesnt want to attach, so see below an extract of the data.

Produce Oxford London 2021 Oxford London 2022
Apples £ 3 £2 £5 £ 3 £1 £4
Bananas £ 4 £7 £11 £7 £0 £7


There are many more columns of data in the full document but I wanted to know if there is a way that i can see which ones have remained the same (i.e same amount spent in same location) and the ones that have changed.

Thank you for the help!

Apologies for the delay and thank you for the help. My account wont let me post a direct link
so here it is broken up

https : / / app. box. com / s / t 402l jnidd 6gef h0iezh7 qf3r51m5z3p

What i would like to do is either have some sort of display that illuminates when there has been movement between years for products and locations.

For example:

Product 599 (in row B8) has values for D8; E8; G8 (i.e values for 2021) but for 2022 it has values for I8; J8; K8: M8.

Is there a way that i can input the name (anything from column B) and it will tell me if there has been any increase / decrease in total value?
In addition to if this is possible, is there a way to see where the movement has occurred (using example above there is a value in I8 but not C8)

Would really appreciate the help and thank you very much for what you have done so far!

Many Thanks

Thank you for the quick reply.

So the cities and products will be consistent year to year.

What I would like to be able to check is whether there has been differences in values for certain products across all the cities.

I.E for b4 there has been changes between both years for Oxford Bath & Bristol but not London and Cambridge. If there was a way of highlighting this (either colour change when value is not consistent or an additional column that stated there was a change)

Is this possible ?

Thank you again for the assistance.

Hi Again,

Apologies for the delay, this is perfect thank you so much for the help!

I guess as another question, is there anyway I can amend this code so that rather than highlighting the revenue it highlights the product code instead?

Thank you so much for your help this is fantastic.

Hi Again,

Fantastic thank you very much for the help on this. A true excel Wizard!

Can the macro continually update or does it need to be run every time?

Thank you again for all your help!

You are very welcome.
Insert this code below the ‘Dim’ line of code;

Please Login or Register  to view this content.

The macro has to be run each time you want to update the sheet.