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

Darren,

Thanks for the video. That makes sense.

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? Yes as I am currently using the XX sheet as a master and then creating my new sheets but I made some updates after the ST sheet was made (as well as several sheets) so I was looking at copying a lot of cell formulas to get the sheets updated.

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? Yes, I could add a check box to Trigger it or when the hidden column cell for the XX changes.

I was looking at trying to stay out of Bridge to do that so I could set things up in control center to set up some cross sheet references and then move them to a gathering sheet so I did not have so many sheets.
The reality is the number of sheets doesn’t matter I just need to build a report to look at all the sheets.

Thanks.