| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copying a block of cells so that it updates automatically
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a block of cells so that it updates automatically
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... "Kiersten L" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copying a block of cells so that it updates automatically
Don't do one cell at a time.
Select the entire block of cells and copy. Select a cell in other worksheet and Paste SpecialPaste LinkOKEsc. Gord Dibben MS Excel MVP On Mon, 6 Oct 2008 12:30:26 -0700, Kiersten L <Kiersten wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| automatically copying cells | Excel Worksheet Functions | |||
| Automatically copying cells to another workbook | Setting up and Configuration of Excel | |||
| Copying columns and automating data updates across worksheets | Excel Discussion (Misc queries) | |||
| copying content of cell automatically to multiple cells | Excel Worksheet Functions | |||
| Is there a way to automatically add columns as the data updates? | Excel Worksheet Functions | |||
Hybrid Mode
