Cell references get mixed up when I sort the data

Copper Contributor

Hi, I set up my organizational budget in a workbook with several tabs (sheets?)  The main page brings in data from other pages, as you'd expect, with simple calculations.

In desktop Excel, if I add rows or columns or sort the second sheet, the master sheet still grabs the data from the right cell - if H12 suddenly becomes H15, the reference moves with it.

But in online excel, it doesn't work correctly - the data from H12 always goes into the calculated cell - the reference doesn't move with the data.

I know I didn't explain that clearly - hopefully someone gets what I mean and has the solution!

1 Reply

Hello @Jenny_Hansell,

 

I must apologize as I am not too familiar with the intricacies of Excel Online. Perhaps the following will be of some use?

 

https://answers.microsoft.com/en-us/msoffice/forum/all/keeping-cell-references-after-sorting/a2cc60c...