View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
TooN TooN is offline
external usenet poster
 
Posts: 35
Default macro move cell with text one to right and one up!

Hello,

I looked in the forum but could not find a good answer for my problem. I
have a sheet with a few hundred lines (download from SAP). The sheet has the
following format:

A B
1 123456
321345
text
2 213453
894352
another text line
3 723467
831487
and another text line!
etc etc

I would like to have a macro that moves the cell that contains the text one
cell to the right and one cell up!

With best regards