insert row...with reference
 

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

insert row...with reference
 

I would consider defining the personal information as a NAMED RANGE with
an OFFSET function that adjusts the size as you add names to the NAME
page....in changes the size of your range.

I would also consider make my cells in the personal information page
absolute rather than relative by using the $ symbol in front of them...


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

insert row...with reference
 

One way:

in your persinfo workbook, use


A1: =INDEX('name'!A:A,ROW())

In article ,
pabs wrote:

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

in the "persInfo" worksheet I simply make refernce to each person using
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 not
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 I
missing??

thanks

Pabs


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

insert row...with reference
 

cool!

thanks Jon..
that's exactly what I needed...works percfect now

later


Pab

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

insert row...with reference
 

Hi John. Actually I have a similar situation. I have a list of names beginning in A15 on sheet(1A). The same names are added to GrPg(1A) beginning in A4 and autofilled on down using formula =IF('1A'!A15=0,"",'1A'!A15). When I add a row on source sheet (1A), I have to add a row on GrPg(1A). I'm not sure I understand the parts of your formula. Will it help me?

Robbyn