macro beginner

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

"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.