Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to transpose linked data and keep it linked? | Excel Worksheet Functions | |||
EPM REPORTS - Exporting 2007 excel reports to 2003 excel report | Setting up and Configuration of Excel | |||
Displaying linked data in excel 2007 when linked file is not avail | Excel Discussion (Misc queries) | |||
In a linked calculation how do I lose the '0' in the linked file? | Excel Worksheet Functions | |||
reports | Excel Discussion (Misc queries) |