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

Debra Dalgleish explains a manual technique here:
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