Hi Team,
If "Save as New... gives you "Date & Formatting Options" to tick and untick what you want. Sheet data & Formatting, Cell linking, Sheet filters and forms, attachments etc. etc.
Why cant there be an option to have "formulas" move with the row to another sheet. If you "Save as New" five times, then you have five sheets that can duplicate each other, "Move to Another Sheet" or "Sort Rows A - Z" wont break the link as it dose with "Cell Linking". This is a game changer for my business and the team in it.