Move cell values

[student]

Hi,

Need a help in Macros.

Suppose i have the foll. data

ColA Col B
1 w
2 re
3 dff
--> Empty cells
1 ed
2 23
3 24

I need to copy the cell with 3 in colA two rows up, so it should be someting
like this:

ColA Col B
1 w 3 dff
2 re
3 dff
--> Empty cells
1 ed 3 24
2 23
3 24


Thanks for help.

 

[David McRitchie]

Hi .........,
I think you messed up your example. Take a look at the following page.

Creating a Table from something like a column of address labels (#snkAddr)
http://www.mvps.org/dmcritchie/excel/snakecol.htm

 

[Don Guillett]

One way
for each c in selection
if c=3 then c.copy c.offset(-3,2)
next c