Look here
http://contextures.com/xlDataEntry02.html

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
ups.com...
I would like the copy content from cell A1 to A2, A3 A4, ETC.
A5 cell content is different and i want copy its content to A6, A7,
A8, ETC.
This sequence repeats for ever.
Is there an array formula or an =if( formula i can insert either below
the
target cell or adjacent to it accomplish such result.

"4508123456"
X
X
X
X
"4508789456"
Y
Y
Y
Y
Y
Y
"4508258258"
Z
Z
Z
Z
Z
Z
In other words, I want to replace X Y Z with number above it ("4508- -
- - - -")
http://crt.fcpages.com/sample%20xls%20file.xls