Copy and paste

[maytwo]

In Column A I need a way to go to end of column A and go up to first row where there is word like "Afni"
then copy down to 1st empty row cut and paste A and B into Column C and D
then keep find next row with word like "Afni" and then copy down to 1st empty row cut and paste A and B in Column E and F
then keep find next row with word like "Afni" and then copy down to 1st empty row cut and paste A and B in Column G and F

 

[SkipVought]

Hi,

This makes no sense to me.

Please post a cogent example.

Skip,
[sub]
Just traded in my old subtlety...
for a NUANCE![/sub]