This might be an answer that is super easy, but I can't quite figure out how to do it. I have a macro that inserts a column as part of a larger procedure. The problem is that there are formulas based on this data on other sheets that change when the column inserts. For example, the formula might be as simple as
=SUM('Insert Raw Data Here'!Z:Z)+Worksheet!F9
The problem is that when the macro that filters and sorts the data inserts a column, the formula shifts to
=SUM('Insert Raw Data Here'!AA:AA)+Worksheet!F9
Is there any way to turn this feature off in a specific workbook? I can't live without it in everything else, but I need to be able to insert this column without the other formulas changing.
Thanks!
=SUM('Insert Raw Data Here'!Z:Z)+Worksheet!F9
The problem is that when the macro that filters and sorts the data inserts a column, the formula shifts to
=SUM('Insert Raw Data Here'!AA:AA)+Worksheet!F9
Is there any way to turn this feature off in a specific workbook? I can't live without it in everything else, but I need to be able to insert this column without the other formulas changing.
Thanks!