COPYING LINKED CELLS

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Open Event 5
Junp start my Select Case Macro 12
Still having VBA problems 1
pricing help 5
Average cells based on column header 6
pasting content copied from nonadajacent cells 1
problem in Excell 2003 4
Copy/Paste 1

Back
Top