Copy relative formula between sheets
In theory, setting the Preserve row and column to off on references in a formula makes them relative.
However when copying a formula with these options set to off between sheets using headers, the sheet::header reference remains absolute. As a result, it still pastes "SHEET_NAME::header" instead of just "header". The only way to do this that I know of is cumbersome:
- Set preserve options off
- view formula as text
- copy text
- view destination cell formula as text
- paste text
It's obviously not ideal as very slow, and I'm sure Apple planned something more efficient to paste relative formulae between sheets.
Anyone know how?
MacBook Pro 13″, macOS 13.6