complex arrays multiple sheets

newbietoexcel123

New Member
Joined
Aug 13, 2013
Messages
1
Good afternoon,

I am struggling to understand arrays. I have read many articles in this forum and in others but I can't seem to get a handle on them.

What I am trying to do seems simple.

I have 3 sheets, sheet 1 has a week column 4 data points columns, sheet 2 and 3 have charts.

I need code to go through 52 lines on sheet 1 and if ("data 4" Column G) is greater than "0" then to copy and paste "week" Column A, "data 1" Column B, "Data 2" Column C, "Data 3" Column D, "data 4" Column G, on sheet 2. The first set of columns(A-E) 1-13 and in the next set of columns(F-J) 14-26 and if there are more than 26 lines that are greater than "0" to continue to paste the information onto sheet 3 in exactly the same format.


Any help with this will be most appreciated as I am lost.

Thank you for your time,
 

Some videos you may like

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Watch MrExcel Video

Forum statistics

Threads
1,123,206
Messages
5,600,317
Members
414,376
Latest member
NickYOW

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