Vba copy and paste different rows

M

mohamadba91

New Member
Joined
Aug 14, 2019
Messages
6
I wanna copy rows number 2 and then 9,16... (i+7) from sheet "daily price data" and paste them on sheet "weekly price data"
can any body help me on this VBA code?
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
Sort by date Sort by votes
You must log in or register to reply here.

Similar threads

PIsabel
  • Question Question
Change prices
Replies
3
Views
72
smozgur
smozgur
P
  • Solved
Move data from a column to another
Replies
6
Views
180
Panoos64
P
B
  • Question Question
VBA to insert rows based on cells column in another sheet (same workbook)
2 3
Replies
22
Views
652
Joe4
Joe4
I
  • Question Question
Filter column on text value if that value exists using VBA
Replies
7
Views
254
Peter_SSs
Peter_SSs
C
  • Solved
Extracting data with VBA macro button from files in designated folder
2 3
Replies
20
Views
822
Micron
M

Forum statistics

Threads
1,223,790
Messages
6,174,594
Members
452,574
Latest member
hang_and_bang

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