Faster way of linking multiple cells between spreadsheets?

[Tech.Zoan]

I have a spreadsheet for each on-going projects and one summary
spreadsheet.

Each time I create a spreadsheet for a new project, I have to go back
and forth between the new spreadsheet and my summary spreadsheet and
go thru the "=" and "Enter" process for each cell i want to link to.

All the cells I want to link to are in one block (row) and I tried to
do the "= and Enter" thing for just the first cell and highlighting
the whole block i wish to link to but it only does a straight copy...
no link is created so when i update the cells later on... my summary
is not being updated.

Any way of doing the linking in one step?

TIA

 

[Dave Peterson]

Try selecting the "sending" range
Edit|copy
Then select the cell in the top left corner of the "receiving" range.
edit|paste special
click the paste link button