I maintain a spreadsheet which contains formulas summing certain cells etc and linking between workbooks. Data is added to the spreadsheet which is then sorted to the correct place in the list. I want the formulas to carry on adding the same data as it did before the new data was added. The problem I have is that the absolute references do not adjust themselves to take account of new data added this way (as it would if rows were inserted). Example attached.
I have tried using name ranges, which has the same result, using the workbook reference but nothing seems to work. If there anyway to force the system to keep the references.
Thanks for your help.
Bookmarks