Copy value below Cell

[Conditional Formatting]

I would like to know if there is a formula that would copy the value of the
data below it.
Sample: (I would like a formula to be created in column B and the result
will be the example below)

Column A Column B
1234 1234
----- 1234
----- 1234
3456 3456
----- 3456
9876 9876
---- 9876
---- 9876
---- 9876
123456 123456
---- 123456

Thank you in advance!

 

[Dave Peterson]

Take a look at Debra Dalgleish's notes:
http://contextures.com/xlDataEntry02.html