So I have an Excel document with 3 Sheets: AS FED, DRY MATTER, SORT BY...
e.g. Cell C4 in 'DRY MATTER' sheet has this formula: ='AS FED'!C4*100/(100-'AS FED'!C$44)
What should I do to unlock those cells? I guess it's a bug with the index + row formula...
Before sorting.png After sorting.png
- The 'AS FEED' sheet contains a table without formulas, just basic numbers.
- The 'DRY MATTER' sheet contains another table, similar with the previous one. All cells with data in them are linked to 'AS FED' sheet via this formula:
e.g. Cell C4 in 'DRY MATTER' sheet has this formula: ='AS FED'!C4*100/(100-'AS FED'!C$44)
- The 'SORT BY...' sheet contains yet another table. It uses the data from 'DRY MATTER' sheet, as you can see in the photos attached below.
What should I do to unlock those cells? I guess it's a bug with the index + row formula...
Before sorting.png After sorting.png