Dynamic Linked Cells

Hi,

How can I keep 3 rows at the top of each sheet dynamically linked so that I can update any of the sheets and all the rest will update?


e.g IF I update A1 in sheet1 then all sheets will update in A1 , but if I then go to sheet3 and change A1 to a different value then they will all update again accordingly.

Thanks in advance.

Try, paste in 'ThisWorkbook' module:

Please Login or Register  to view this content.

Hi Porucha,

thanks for quick response this is the closest to what I need so far that I have found - I wondered if you could help with a couple tweaks.

It starts to work but after a few different cells are edited is comes up with the below error I have print screened and then it works again.

I should have also mentioned that I am trying to get it to link checkboxes and not texts or numbers and while text is working the ticks do not

I have attached a sample workbook so you can understand I would like all 3 pages to link so that I can double click in the cells and it will update all 3.

Chillibolt,
In the "ThisWorkbook" module, not in individual sheet modules ...

Hi great,

I have got it to work really well now, but can you organise it to work with a checkbox via also.

I have attached a ticklist VBA running on this attachment but I would like to be able to do the same with the ticks on every page

Please see attached doc to understand and see that it doesn't replicate on the other pages.