S
Susan
I need help in offset function. There are 2 sheets, a detail sheet which has steven name in a11, and the next name is in a22, I need to bring steven name in summary sheet(new worksheet), but when I copy the formula it just brings the next cell, I need to link that cell so if I insert or delete a line it still points to the same nam
Exampl
Detail Shee
a1Steven C.
a2
a3
a4 Steven C. Tota
a5
a6 Joseph B.
a7
a8Joseph B. Tota
Summary Sheet
a1Steven C. Total - I want that linked to that cel
The numbers of line can increase or decrease in the detail sheet, but I still need the result in a2 of Joseph nam
a2Joseph B.
Help????
Susan
Exampl
Detail Shee
a1Steven C.
a2
a3
a4 Steven C. Tota
a5
a6 Joseph B.
a7
a8Joseph B. Tota
Summary Sheet
a1Steven C. Total - I want that linked to that cel
The numbers of line can increase or decrease in the detail sheet, but I still need the result in a2 of Joseph nam
a2Joseph B.
Help????
Susan