2 sheets linked together

[Jarae]

Hi,
I have 2 excel sheets linked. Sheet 1 is BKY Sheet 2 is Day Sheet. I have formulas that copy info from BKY to Day sheet, however when I add a person (ie-on row 6) that information not show up on the Day Sheet. How do I resolve this problem?
I add a line above and it changes my formula on the Day sheet to recognize the previous info that was posted.

Attached file is called linked sheets - excel forum

Thanks

[6StringJazzer]

How are you adding a person on row 6? Are you inserting a new row? Your formulas won't work for that. When your formula references =A6, then you insert a row, Excel automatically updates it to =A7 so that it keeps pointing to the same cell (i.e., the same original data).

The easiest solution is to simply type in new data after the last row, without doing Insert.

The next-easiest solution is to change the formulas on Day Sheet from

=bky!C6

to

=INDEX(bky!C:C,ROW()+3)

You can put that formula in B3 then copy to all other cells. See attached.