G
Guest
Is there a formula I can put on a worksheet that picks up the values from the
last row entered in the previous sheet, changing as rows are added.
In other words, this forumla in A1 of sheet 2 would show the value of A20 in
sheet 1 until values were put into A21, then they would show the values from
A21, then A22, etc.
last row entered in the previous sheet, changing as rows are added.
In other words, this forumla in A1 of sheet 2 would show the value of A20 in
sheet 1 until values were put into A21, then they would show the values from
A21, then A22, etc.