Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro beginner
"Erica" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
macro beginner | Excel Programming | |||
macro help for a beginner | Excel Programming | |||
macro help for a beginner | Excel Programming | |||
macro help for a beginner | Excel Programming | |||
macro help for a beginner | Excel Programming |