Based upon your earlier requirements, this should be all you need to do:
Ensure that you have a header row in your first and second sheet (otherwise AddRow returns an error)
You will notice a third data point, which is empty, this ensures that the formula in column C is not overwritten (useful if using an arrayformula to generate the formula).