Paste cell selection multyply times

[vivis93]

Hi can i paste cell selection multiply times each after 13 rows, the number of how many times to be pasted to be from a cell eg. F1(12), also some formula in that are in the selection range to be updated automatically with the row number til to the number in cell F1 eg. =A1+B1 to =A2+B2.........=A12+B12

 

[joygpilare]

In the cell that has the formula, click on the bottom right corner and drag it down to where you want it to end.

 

[vivis93]

In the cell that has the formula, click on the bottom right corner and drag it down to where you want it to end.

I dont have only one cell there are range of cells eg. A1:C10

 

[joygpilare]

I'm sorry, I don't believe I fully understand what you are working with.

You are able to highlight multiple cells in a row and drag the formula down to copy.

Highlight A2:A10 and drag down to C2:C10.

 

[vivis93]

I'm sorry, I don't believe I fully understand what you are working with.

You are able to highlight multiple cells in a row and drag the formula down to copy.

Highlight A2:A10 and drag down to C2:C10.

Yes but i want all this process to be automated using vba code also this action to be performet x times; after 13 rows eg. A2:A10 ----at cell A13 to be pasted and after that again + 13 rows--->A26.

 

[joygpilare]

Sorry, beyond my scope. Not familiar with VBA... Best of luck!

 

[vivis93]

Sorry, beyond my scope. Not familiar with VBA... Best of luck!

thanx man for trying to help, all the best