I am working on a workbook where we have to link a selected range of sells
to several other worksheets in the same work book.

E.g. €“

I have to link range of cell C 5 to E5 in worksheets 2,3,4,5,6, & 7 to the
cell range C5 to E5 in Sheet 1. At this point I am copying the link to
individual sheets , and this proving to be very time consuming.

Is there some way I could do a global link to the cell range for the said
work sheets so that I can save on time €“ that is link C5 TO E5 in Worksheets
2,3,4,5,6 & 7 to the C5 to E5 cell range in Work sheet without having to copy
the link to individual worksheets.

Thank you for your assistance

Prasad