moving items within the page
 

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

moving items within the page
 

On May 30, 3:38 pm, Alan wrote:
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 EditPaste Special...
check Transpose.

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

Copy either formula to the right.

HTH
Kostis Vezerides