G
Guest
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
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