moving row to multiple sheets
I would like to move one row to multiple sheets at the same time. I have a setup that utilizes what I call "duplicate tables" whose job it is to receive the row and move it to the corresponding table. The challenge is I need a duplicate table for each move which could get clunky.
Has anyone had a similar need? I'd love to hear what solutions were used.