Feb 21 2020 07:37 AM
Hi. I'll try to explain this as best I can. I have two workbooks: I enter monthly financial updates into one (let's call this one the data workbook), and the second one is composed of compiled data from the first (we'll call this one SG). The formulas in the SG correlate with specific sequences in the data workbook. My problem is that any time I insert a new row to the data workbook, the formulas in the SG stay linked to the same cells, and my totals are thrown off (it's financial data, so this can be a big problem). Is there a way to have the formulas link to specific sequences, rather than specific cells? Here's an example of what I thought would fix it, but it did not. !$AT$392
I thought the "$" would keep the formula linked to the sequence rather than the cell, but that doesn't appear to be the case. These workbooks are huge, so it's not always easy to catch when a formula has "slipped", any help would be extremely appreciated.
Feb 21 2020 10:21 AM