Debra Dalgleish explains a manual technique he
http://contextures.com/xlDataEntry02.html


Santhosh Mani wrote:

My range is A1 to A10. Cell A1 I enter 100, cell A4 = 200, Cell 7 = 300.
Rest all cells in my range are blank. Now I want to copy 100 in A2, A3, 200
in A5, A6 and 300 in A8, A9, A10. Is it this possible through commands, like
Edit, goto, constants, then copy the select the blank cells and fill with the
corresponding upper contents. I am not looking for any VB code, just with the
help of multible menu commands. Pls help

--

Dave Peterson