linked formula on multiple sheets

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

skiing - 17 Mar 2008 18:47 GMT

I have a very simple linked formula ( i.e. =personnel!C1 ) which I
use on multiple sheets to reference the "main" sheet titled personnel
and cell reference C1.
( lets title the sheets for simplicity 1) Personnel 2) Task 3)
Info )

If I modify the contents of personnel!C1 -- all sheets are modified as
well.

But if I sort the personnel sheet - the adjacent sheet ( sheet Task)
will adjust the formula to reference the new sorted position - but
reference is not updated in the next sheet ( sheet Info )?

I have tried multiple processes using relative/absolute addressing but
have been unable to get sheets Task AND Info to update.

Can anyone assist?

thank you !!!

Reply to this Message

Héctor Miguel - 18 Mar 2008 06:59 GMT

hi, !

1) I guess "the formula" is not as "very simple" as you posted: -> ( i.e. =personnel!C1 )

2) it's not clear what the meaning is for : "the new sorted position" (after sorting personnel sheet):
"the adjacent shet ... adjust the formula to reference *the new sorted* position"

3) AFAIK & FWIW, linked formulae does NOT "follow" (original) data to their (new) "sorted position"
however, hard-formats DO "follow" cells/data to their new sorted position (but I think this is not the case)

4) perhaps, "linking" formulae (to the original data) with functions like vlookup(..., index(..., match(..., -?-

hth,
hector.

> I have a very simple linked formula ( i.e. =personnel!C1 )
> which I use on multiple sheets to reference the "main" sheet titled personnel and cell reference C1.
[quoted text clipped - 8 lines]
> I have tried multiple processes using relative/absolute addressing
> but have been unable to get sheets Task AND Info to update...

Reply to this Message