I have a worksheet with a a list of names in it (name). and anothe
sheet (persInfo) with all the information pertinent to all the peopl
in the "name" worsksheet.

in the "persInfo" worksheet I simply make refernce to each person usin
the following formula

='name'!A1
the next row will have
='name'!A2

and so on....

my problem is if I insert a row in the "name" worksheet it does no
update it in the "persInfo" worksheet

let's say I insert a name at row 10 in my "name" worksheet
In my "persInfo" it will now go from
='name'!A9 to ='name'!A11.
normally it would have been ='name'!A9 and ='name'!A10

it skips the row that was added.
I would like to be able to have the new rider added ...what Am
missing??

thanks

Pab

--
Message posted from http://www.ExcelForum.com