Hi, I'm sure this is simple but I haven't been able to modify any VBA code I've found to do what I want. Hopefully someone can help.
What I need to do is copy the values in A2:C2 to G2:I2, and then copy the value of M2(value, not the formula) to D2. Then I want to move onto copying A3:C3 to G2:I2 and then copy the value of M2 to D3. So basically cycle down through columns A:C until there is no more data in those columns and each time copy the values of the new row to G2:I2 and copy E2 to column D for the row in question. Columns E and G:I will only ever be populated in row 2 at any time. Screenshot included. Any help much appreciated.
What I need to do is copy the values in A2:C2 to G2:I2, and then copy the value of M2(value, not the formula) to D2. Then I want to move onto copying A3:C3 to G2:I2 and then copy the value of M2 to D3. So basically cycle down through columns A:C until there is no more data in those columns and each time copy the values of the new row to G2:I2 and copy E2 to column D for the row in question. Columns E and G:I will only ever be populated in row 2 at any time. Screenshot included. Any help much appreciated.