Paste cell selection multyply times

V

vivis93

New Member
Joined
Sep 12, 2015
Messages
21
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
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Sort by date Sort by votes
In the cell that has the formula, click on the bottom right corner and drag it down to where you want it to end.
 
Upvote 0
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.
 
Last edited:
Upvote 0
joygpilare said:
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.
Click to expand...

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.
 
Upvote 0
You must log in or register to reply here.

Similar threads

Jeffrey Mahoney
  • Question
Copy Filtered Rows and Paste to Different Column
Replies
1
Views
90
Akuini
Akuini
A
  • Question
VBA Userform List Box to Populate upon entering a specific text in Column B, copy data upon selection and paste data in the same Row in another Column
Replies
3
Views
184
arijitirf
A
J
  • Solved
VBA to have user select a cell in column A have a 1 placed as a result of selection and a 2 placed in the next selected, etc
2
Replies
15
Views
453
NoSparks
N
U
  • Solved
Copy/Paste Rows on select criteria
Replies
4
Views
826
UTB
U
D
  • Question
Pasting string - variable in cell - ERROR
Replies
9
Views
270
Alex Blakenburg
A

Forum statistics

Threads
1,214,990
Messages
6,122,626
Members
449,094
Latest member
bsb1122

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top