Faster way of linking multiple cells between spreadsheets?

T

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
 
D

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
 

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

Problem linking to a cell with a date. 1
Differences Between Two Spreadsheets ? 1
Using vlookup to populate multiple rows at once 5
Linking Cells Between Sheets 5
how to return "summary" of all non-blank cells plus their headers 10
handling links to external spreadsheets 2
Linking a multiple spreadsheets to a master spreadsheet 2
importing data in differing time frames 1

Top