#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Linked Reports

I need to link three spreadsheets together and when the first spreadsheet is
updated I need it to update the other spreadsheets. The problem is if I
add/delete a row in the first spreadsheet the change doesn't carry over and
then I need to redo the entire worksheet. Any suggestions?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 258
Default Linked Reports

SF --

If I understand it, you want to add rows simultaneously to multiple
worksheets. To do that:
1) Select the first one.
2) If they're contiguous, shift-select the last one. If they're separated
by other sheets you don't want to mess with, ctrl-select each one.
3) Do what you're going to do. Remember that, until you select a worksheet
other than the ones with which you've been working, you'll continue to do the
same action to all of them. That can make some problems for you, so be
careful.

HTH

"soulfire" wrote:

I need to link three spreadsheets together and when the first spreadsheet is
updated I need it to update the other spreadsheets. The problem is if I
add/delete a row in the first spreadsheet the change doesn't carry over and
then I need to redo the entire worksheet. Any suggestions?

Reply
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
How to transpose linked data and keep it linked? Amy Excel Worksheet Functions 3 May 2nd 08 04:11 PM
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report Prashanthi Setting up and Configuration of Excel 0 February 18th 08 04:02 PM
Displaying linked data in excel 2007 when linked file is not avail Eng_19 Excel Discussion (Misc queries) 0 December 7th 07 08:27 PM
In a linked calculation how do I lose the '0' in the linked file? Anita Excel Worksheet Functions 2 February 3rd 06 02:54 PM
reports herbzee Excel Discussion (Misc queries) 5 March 1st 05 11:25 PM


All times are GMT +1. The time now is 01:02 PM.

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

About Us

"It's about Microsoft Excel"