copy block of info

  1. amitcohen

    Macro to Copy and paste in interval of 7 rows

    Hi All Hope you can help me.. I need to copy a range of cells (A3:J43) and then to paste it 7 rows under the previous paste. This need to take place 100 times. In other words: Copy 40 rows Jump 7 rows (from the last cell of the range) paste the 40 rows jump 7 rows (from the last cell of the...
  2. M

    Formula for worksheet needed

    I am a nurse administering vaccinations for the commonwealth of Massachusetts. I have one book with several sheets, one sheet for each formulation of flu and one sheet that’s keeping track of my totals. I’d like to create a sheet that will be a distribution log which I’ll give to the people...

Watch MrExcel Video

This Week's Hot Topics

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
Top