Support Board
Date/Time: Sun, 09 Feb 2025 04:09:44 +0000
Post From: Own calculations on Quote spreadsheet, cell references not updated
[2020-08-04 19:31:39] |
TeeJay - Posts: 123 |
What I do is : After the last filled row on the quote spreadsheet I enter a new symbol through making an entry in Column A, row xx (first free row). This entry is then automatically sorted into the quote list above. Let's say it is sorted into row 3, which puts row 9 into row 10 effectively. Now I have the field in Z2 that referenced G9. And this is not updated to G10 then if doing it that way. The functionality for appending like that is there, so it would be great if also the referencing would work that way. I cannot even manually insert a row because in the middle of the field rows (quotes). As soon as I do that the rows are re-sorted. Which is great if the referencing would work. Thanks |