S
skiing
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 !!!
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 !!!