Enter a number on different cells automatically ?

T

toyota58

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.
 
J

Jacob Skaria

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
 
J

Jacob Skaria

If you have other information in A4,A5,A7 etc; copy this formula to the
required cells (A6,A9,A12,A15,A18)

=IF($A$3="","",$A$3)

If this post helps click Yes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bug in Excel? 2
IF Statement problem 3
Maximum Number of Blank Cells between Non Blank Cells in a Range 5
Remove specific cells in a column. 2
Data Compare 1
Auto row insertion based on a number 6
sum if 1
Autofill cells in 1 column :code ?? 2

Top