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

Select sheet2 and SHIFT + click on sheet7 to group these sheets.

On sheet2 in a cell enter =sheet1!C5 and ENTER

Copy across two more cells.

Click on sheet1 tab to release the sheets from the group mode.

See each sheet2 through sheet7 has your links to sheet1.


Gord Dibben MS Excel MVP

On Tue, 13 Feb 2007 10:15:00 -0800, Prasad Gopinath
wrote:


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