moving items within the page

[Guest]

I have say an item i need moving from say c340 and i need it to be moved to
d339 and then a nother item moved from c341 and i need it moved to e339 and
this is all in a colm i then need to deleate 340 and 341 rows i use to do it
by writing a little macro but not sure how to do it within Xp as it seem to
be specific to what you are typing and not random can anyone help

 

[vezerid]

I have say an item i need moving from say c340 and i need it to be moved to
d339 and then a nother item moved from c341 and i need it moved to e339 and
this is all in a colm i then need to deleate 340 and 341 rows i use to do it
by writing a little macro but not sure how to do it within Xp as it seem to
be specific to what you are typing and not random can anyone help

Some tools:
If you copy C340:C341 and then select D339 and Edit>Paste Special...>
check Transpose.

If you want to do this with formulas, in D339:
=OFFSET($C$340,COLUMNS($D$339339)-1,0) --or somewhat simpler:
=OFFSET($C$339,COLUMNS($D$339339),0)

Copy either formula to the right.

HTH
Kostis Vezerides