Cell references get mixed up when I sort the data

Occasional Visitor

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?