Sorting linked worksheets
I'm using a massive workbook with multiple linked worksheets. Unfortunately,
when I sort one of the 'master' worksheets, my links are scrambled because
they follow the cell rather than the data.
To illuminate the issue, I have separate 'master' worksheets for
"capabilities" and for "enablers" - these are linked in subsequent worksheets
using the ='Enabler Definitions'!Bxx function.
Is there a simple way of curing this problem?
|