Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how to copy multiple cells into one cell | Excel Discussion (Misc queries) | |||
copy a cell from multiple worksheet | Excel Discussion (Misc queries) | |||
Copy multiple cells to one cell | Excel Discussion (Misc queries) | |||
Copy Multiple Rows into One Cell | Excel Discussion (Misc queries) | |||
Copy Cell to Same Cell on Multiple Sheets | Excel Programming |