How can one have a function/formula that when one character is entered into a cell, one formula is copied from two cells (from the same place each time) into the corresponding specified row. And if another character is entered ino the same cell, another formula is copied from two cells (frm the same place each time) into the corresponding specified row?

Eg.

If 'Y' is entered - Copy formula from Cell C1 & D1 to C10 & D10
If 'N' is entered - Copy formula from Cell C2 & D2 to C10 & D10

When the cell formula is copied it needs to automatically update so if it's copied to C10 it uses that rows data, and if is copied to C11 it uses that rows data.

Thanks.