hi all
I have some cells in a column which I want to replicate across the spreadsheet: like copy N cells and paste starting from the next available cell in the same column,; I need to do that many times: meaning for example, 10 cells to fill about 13000 cells downward.
how can I do that quickly?
also, how can I record a macro in such a way that the cells are variable and not fixed?
Last edited by alisam; 11-22-2011 at 11:15 AM.
A little more clarification.
Let's say cells A1:A10 are filled...what do you want to happen from there?
Do you want those numbers filled down starting at A11 until x number of times are complete?
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
yes exactely: i want to replicate A1:A10 x times
Try this...
Place your cursor in A1 and then hit the button...
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
it helped thanks: is there a possibility to make it more generic? as in instead of column A, any chosen column and being able to choose the times I want to replicate?
Try this variation. Just select the first cell in the column and then hit the button to enter the number of times to replicate.
HTH
Regards, Jeff
If you like the answer(s) provided, why not add some reputation by clicking the * below
Please use [ Code ] tags when posting [ /Code ]
Please view/read the Forum rules --- How to mark a thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks