If data in Sheet2 is linked to Sheet1
Example:
Sheet1
.......A.........B.........C
1 ..Data....Data.....Data
2 ..Data....Data....Data
Sheet2
.............A...............B..............C
1 =Sheet1!A1 =Sheet1!B1 =Sheet1!C1
2 =Sheet1!A2 =Sheet1!B2 =Sheet1!C2
How do I insert a new Row 2 in Sheet1, that would automatically insert into Sheet2 in the same location and have the same formulas as the row above so that any data entered on Sheet1 also is filtered down into Sheet2?
Thanks!
Bookmarks