I have a sheet where a third of the data provided is from an Oracle, another third pulled from another sheet, and the rest are calculations based on the previous.
I am having an issue with one column in particular that s pulling data from another sheet. My Formula reads
Code:
='Current Status'!$G$2
with the cell reference changing accordingly. When the table is refreshed it reverts back to the original formula and all cell references are lost.