H
h2fcell
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?
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?