Mirror multiple cells across multiple worksheets.

Hi,

I have a workbook with multiple sheets:

2012, 2013, 2014, 2015, 2016, 2017, ANALYSIS

Cells A1 and A2 on all the dated pages are linked to cells A1 & A2 on the ANALYSIS.

I want to be able to change the value of A1 & A2 on any of the sheets and it reflect across all the others.

Currently I have to switch back to the ANALYSIS sheet every time I need to change the value.

(see attached)

Is there a nice way of linking the cells in both directions?



My VB experience is extremely slim so please dumb it right down if possible.

Thanks in advance for any help

Hi,

Thanks for that.

However I was looking for a more permanent way. I'm not the only person using this workbook, so it needs to just happen automatically.

Plus there are other sheets in the workbook which I don't want linked. So would have to manually group specific sheets each time.