Suppose Cell A3 = 2019

In cell A6 Enter formula
=IF(A3<"",A3,"")

Copy OR Drag the same formula down from A6: to the number of rows required.

If this post helps click Yes
---------------
Jacob Skaria


" wrote:

Hello,

I want to enter a number on different cells automatically. I want to
do this so I don't need to repeat the process again and again. I want
to enter a number on cell A3 and the same number will appear on cell
A6, A9, A12, A15 and A18 automatically. When I delete the number on
cell A3, the number will also dissapear from cell A6, A9, A12, A15 and
A18 automatically too.

Example Cell A3 2019

A6 2019

A9 2019

A12 2019

A15 2019

A18 2019


Thank You.