Linked sheets - Insert rows in all sheets? 
Author Message
 Linked sheets - Insert rows in all sheets?

Phil

If your desire to insert rows on Sheets 2 & 3 is so that the formulas on
those sheets continue to properly reference sheet1 (when a row is
inserted there), then you might try using a combination of the Index &
Match functions to "lookup" the value based on it's position within the
data.

For example, let's say you have a data range of A5:B8 on Sheet1. A5:A8
contain the Row headings "North", "East", "Central", & "West".  B5:B8
contain sales figures for each of those geographical regions. Your goal
is to reference/place the "Central" sales figure in cell D10 of Sheet2.
Place the following formula in Sheet2, D10. Should you decide to insert
a row within the Sheet1 data range, this formula will still properly
locate the "Central" sales figure:

=INDEX(Sheet1!$A$5:$D$8,MATCH("Central",Sheet1!$A$5:$A8,0),2)

Warning: Cutting & pasting the Sheet1 data WILL destroy the reference;
inserting/deleting rows will not (so long as the row you delete is NOT
"Central").  <g>

Hope that was what you were looking for.

Sincerely,
---
Robert Rosenberg
Microsoft MVP - Excel
----------------



Wed, 18 Jun 1902 08:00:00 GMT  
 Linked sheets - Insert rows in all sheets?

Hi Phil.
        You can Group sheets 1,2&3 . Hold down shift key and left click mouse on
the sheet tabs you want to Group. Now insert the rows.
**WARNING!**  do not forget to ungroup sheets, Right click any ungrouped
sheet tab, or right click  grouped sheet tab and select Ungroup Sheets.
***What you do to one sheet, you do to all grouped sheets.***

--
All The Best

George

Newcastle Upon Tyne
England



Wed, 18 Jun 1902 08:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Inserting rows in linked Excel sheet.

2. copy row from sheet 1 to next open row on sheet 2

3. Copying rows from multiple sheets to a new sheet

4. Creating a separate sheet from each row in one sheet

5. Checking the row data of First Sheet and deleting the related data from the second sheet

6. Inserting data on one sheet from another sheet

7. Linking info in one sheet to another sheet

8. Macro to past link from Sheet 1 to Sheet 2

9. VBA to link cell on one sheet to cell on another sheet

10. Linking Sheet Tab Name to Cell in Current Sheet


 
Powered by phpBB® Forum Software © phpBB Group