Reply To: Copying/moving a row from sheet to sheet with cell formulas

Kevin,
In those example sheets, would the goal be to copy the row from the XX sheet to the ST sheet, keep the formulas, then manually put it into the correct hierarchy?

We can obviously update the formulas in the cells in the ST sheet from the XX sheet, but that’s assuming the row already exists in the ST sheet.

If you want to copy a row from the XX sheet to the ST sheet and keep all the formulas, we could do that too, but what would be the trigger from the XX sheet?

By the way, I’d like to make a video eventually showing the solution, so I’m going to make a couple sheets to show the principles in Bridge, then you can duplicate for your use case.

I don’t want to work on your live sheets anyway!!!!