Hello
I have a long nested formula in one tab which refers to data in another tab.
When you step into a formula that references data on the same tab the range highlights in blue and, if you want to, you can drag this range to reference other cells.
Is this possible when the data being referenced is on another tab?
I have a long nested formula in one tab which refers to data in another tab.
When you step into a formula that references data on the same tab the range highlights in blue and, if you want to, you can drag this range to reference other cells.
Is this possible when the data being referenced is on another tab?