Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving a paragraph to the next page. | Excel Discussion (Misc queries) | |||
Moving information to a different page | Excel Worksheet Functions | |||
How to pick one or more items out of a list, moving to new list, moving up or down. (form) | Excel Discussion (Misc queries) | |||
Chart items moving around | Excel Discussion (Misc queries) | |||
Chart items moving around | Charts and Charting in Excel |