Copying a block of cells so that it updates automatically

K

Kiersten L

I need to copy a block of cells into another worksheet so that it references
the existing file so that it will automatically update when I open the
document. I would prefer to not link each cell individually because that
will take forever and if I embed the range of cells as an object or a link,
the values won't update automatically. Is there anyway to do this?
 
S

Sean Timmons

if it's just a block of cells, then in the other workbook, type =, then click
the top left cell you want to tie in. Then copy this formula down and to the
right to cover all cells...
 
G

Gord Dibben

Don't do one cell at a time.

Select the entire block of cells and copy.

Select a cell in other worksheet and Paste Special>Paste Link>OK>Esc.


Gord Dibben MS Excel MVP

On Mon, 6 Oct 2008 12:30:26 -0700, Kiersten L <Kiersten
 

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

linking a range of cells (=) to another range 4
Can I format one cell so that it affects another cell? 4
How do I add an equals sign to a cell that already has numbers in 6
Help with converting a block of cells with Absolute and mixed references to relative references 3
Can I link cells so that copying one copies all? 4
Can trendline equations be automatically entered into cells? 1
Cells w/ user defined function do not auto update 2
link a range of cells 4

Top