LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
automatically copying cells Anna23 Excel Worksheet Functions 1 February 6th 08 11:23 PM
Automatically copying cells to another workbook Just Askin Setting up and Configuration of Excel 1 July 13th 07 08:06 AM
Copying columns and automating data updates across worksheets jkl Excel Discussion (Misc queries) 3 February 13th 07 07:04 PM
copying content of cell automatically to multiple cells PAUL GRAZIDE Excel Worksheet Functions 1 June 4th 05 06:52 PM
Is there a way to automatically add columns as the data updates? Eric D. Excel Worksheet Functions 1 February 24th 05 05:07 AM


All times are GMT +1. The time now is 04:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"