How can I automatically update the cell-link location?
For my Restaurants Food Cost Calculations I refer from my recipe-sheet to the price on my ingredients-sheet. By doing this I just have to adjust the price only once to have all my recipes (70+) prices updated.
I sort the ingredients on the ingredients-sheet in an alphabetical order. Now I added some ingredients and the location of the cells has shifted down.
The link on my recipe-sheet refers still to the old cell though, now showing me an incorrect price.
Is there any way to have LibreOffice Calc to automatically grab the original cell, after location has changed?
Thanks so much in advance for your answers!
===This is only a bump to put the question on top again for other visitors to the site. (Lupp)===