Hi all,

I have a monthly calendar which gets sent out to various product managers around the world. Every month they update the sheet in Excel Online by moving their respective flag (a picture file) to where it belongs in the year. These can change every month. New ones can be added, and flags can also be deleted. Is there a better way to build this for analytical purposes, i.e. if a flag is on cell L19, cell L19 automatically generates a value (EU in this case). This way I can run analysis on how many items are in July, for example, and by extension, how many from each world region.

It doesn't have to be a flag solution. If there is a better way to do this, I'm all ears.

Thanks!

2018-12-11_16h12_05.png