Please can you help with the following problem:

I would like to apply formulas in say Row 5, to the following cells:

F5, H5, J5, K5, O5, P5, T5, U5, Y5, Z5.

These formulas are the copied from Row 5 to Row 10,000.

The problem is, if I make a mistake in inputting data and I then need to
clear the contents of a cell or an entire row, the formulas are lost in that
row. How can I ensure that the formulas are not lost and still able to input
data in the cleared cells.

Mnay thanks,