Hi Paul,

My data isn't uniform like the sample (there wont be blanks in the same way), probably a poor sample by me! So I need another approach.

Is it at all possible to follow the logic below:


For each row (of selection on Sheet1)
IF column C reads "C" then copy Sheet1.D paste to Sheet2.D
and
copy Sheet1.E paste to Sheet2.E and so on...

Then

For each row (of selection)
IF column C reads "D" then copy Sheet1.F paste to Sheet2.D
and
copy Sheet1.G paste to Sheet2.E and so on...

Repeat for entire selection on Sheet 1

Paste in destination starting from first blank row. I have left the row numbers out because these would change based on when the code encounters a specific value in column C on sheet 1 and where the first blank row is on sheet 2.

Thanks again!