VBA Copy and Paste Loop Help

sabertstxvii

New Member
Joined
Feb 14, 2012
Messages
6
Hey all,

Long time lurker, first time poster.

I always try and find my answers before asking, but my mind is in a meatball in this one as I have very little VBA experience.

I have a workbook with essentially 3 columns that are important.

Sheet 1: Has the data that I need to input into Sheet 2.
Sheet 2: Has all of the formulas that autopopulate all of the data I need to copy onto Sheet 3.
Sheet 3: Just where I want to house all of the data from the formulas that auto populate from sheet 2.

To make this example easiest, assume on Sheet 1, Column B and Column E I have 25 rows of data. I need to copy Row B1 and E1 into Sheet 2. Once in Sheet 2, I need to copy D3, E4, J6, L7 and F10, G10 into Sheet 3. Then I need to go back to Sheet 1, and start over with the loop and do B2 and E2 back to Sheet 2...and continue until there are no rows left in sheet 1.

Help! Thanks in advance.
 

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.
Sorry 2 typos that may help clarify:

1. I have a workbook with essentially 3 SHEETS that are important....

2. assume on Sheet 1, there are 25 rows of data. I need to copy CELL B1 and E1.
 
Upvote 0

Forum statistics

Threads
1,213,560
Messages
6,114,306
Members
448,564
Latest member
ED38

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