"Erica" <Erica@discussions.microsoft.com> wrote in message
news:91F48DB1-867A-4823-BD6C-0A5983C54FE5@microsoft.com...
> Hi, I would like a macro that from one column cuts and pasts from every
2nd
> row into the next (2nd) column (one row up) and that for every 3rd row
cuts
> and past that value into the 3rd column (also one row up). I have recorded
> the macro but the cell values are fixed. Thanks!
>
> Erica

Adding an .offset(row,col) to your value assignments should do it.
I'm sure someone(s) will offer suggestions/changes if you post your recorded
macro.