| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can Excel Link two tables on seperate sheets?
I'm using Excel 2007.
I have table1 on sheet1 and table2 on sheet2. The first three columns of table2 are referencing the first three columns of table1 using =+Sheet1!A1, =+Sheet1!B1 and =+Sheet1!C1 down to row 900. If I insert a table row in sheet1 (say between rows 9 and 10) I'd like the same thing to happen to sheet2. Is this something that can only be done with code? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| add two cells from seperate work sheets into a cell on seperate wo | Excel Worksheet Functions | |||
| Can I group or link sheets in seperate workbooks? | Excel Discussion (Misc queries) | |||
| how do I print seperate excel tab sheets in duplex | Excel Discussion (Misc queries) | |||
| Can I link spreadsheets in two SEPERATE instances of excel? | Setting up and Configuration of Excel | |||
| Is there a way to subtotal to seperate sheets in excel? | Excel Worksheet Functions | |||
Threaded Mode
