I am copying tables and pasting them in the same sheet in new locations but some of the formulas carry over and give new Columns references as expected but others don't? I have to manually bring the formulas over to the new cells location?
Thanks for any ideas.
[Link edited by Moderator]
MacBook Pro 15″, macOS 13.0
$ anchors aren't evenly written in the code.
To respect a new Column past, the original cell needs a reference like $A1.
To respect being pasted further down the same Column the Row needs anchoring so it's A$1.
The error was caused because I left the "$" anchor (respecting) Columns in the top left table that was the original source for all further 18 tables (6 x 3) pasted into the sheet because I pasted the first copied table further down the columns and to convert the code back to respect Rows so I could then paste to the right of the first top left table.
Basically $A1 and you can paste vertically below the table and A$1 and you can paste it horizontally.
Why do some of my Formulas Copy and Paste into New Cells but others keep the Original Cell References not the New Ones?
