moving items within the page

A

Alan

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
 
V

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
Click to expand...

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$339:D339)-1,0) --or somewhat simpler:
=OFFSET($C$339,COLUMNS($D$339:D339),0)

Copy either formula to the right.

HTH
Kostis Vezerides
 
Top