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,
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,
