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.
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

sabertstxvii

New Member
Joined
Feb 14, 2012
Messages
6
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.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,265
Messages
5,600,605
Members
414,393
Latest member
Vignesh Mechz

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