I have a file with multiple tabs. The first tab is a table that is autofiltered. All of the following tabs have multiple cells referring back to the first tab using "=firsttab!A34" etc.
The problem is that when i filter the first tab, all my links on the following tabs change.
How do I make my references stick while filtering? do i have to "F4" every single reference formula? would that even work?
The problem is that when i filter the first tab, all my links on the following tabs change.
How do I make my references stick while filtering? do i have to "F4" every single reference formula? would that even work?