Can you set up a sheet so certain columns of any children mirror that of the parent?

Tanya Boehmke

Instead of entering a formula in each cell, can you for instance make columns 3-6 in a child's row match that of the parent's row? And apply that to the entire sheet for all Children?

Paul Newcome

You would need a formula, but based on exactly how you want it to work, it could be relatively easy to populate this formula into every row.