Create a bi-directional link between multiple cells in two different sheets

[kate81]

I have a large set of data on sheet 1 of my workbook which is difficult to read and navigate. Different members of my team need to view different segments of the data, and so I am hoping to create some new sheets in the workbook which pull through selected data from the master sheet - basically creating some 'custom views' of the data to make it easier to view.

My issue is that users are likely to want to edit data from the 'custom views', but I also need to be able to continue to edit data from the master sheet too. So, I need a bi-directional link between the two. I've seen various VBA code examples for linking individual cells between sheets, but I can't seem to find anything that allows ranges of data to be linked in the same way.

For example, on my master sheet I have a table which is range A1:BA400. On 'custom sheet 1' I would like the user to just see ranges A1:C400 and then AS1:BA400. On 'custom sheet 2' I would like the user to just see ranges A1:C400 and then W1:AS400

Might anyone be able to help, or point me in the right direction?

Thanks in advance

 

[offthelip]

welcome to the forum, Have a look at this thread I think the code I posted there will do what you want:
How to make a copy of selected columns of a table in another sheet

 

[kate81]

Thanks so much - this is perfect and does exactly what I need

 

[offthelip]

Glad to be able to help