Re: Macro that deletes every third row....+


You guys are awesome. Most of this worked except the last segment
doesn't repeat. Every third row deletes and then it will take A2 and
move it to B1 and then take the first 12 characters and move them to
C1. How can we make it repeat? I need _all_ the even numbered A column
cells to be moved over and then consolidate the A column. For Example
(after every third line has been deleted):

APPLE
123456789456 ABC
BANANA
321654987321 DEF
CARROT
456789123456 GHI
DOG
321654987987 JKL

APPLE 123456789456 ABC
321654987321 DEF
BANANA 456789123456 GHI
321654987987 JKL
CARROT

DOG

APPLE 123456789456 ABC 123456789456
BANANA 321654987321 DEF 321654987321
CARROT 456789123456 GHI 456789123456
DOG 321654987987 JKL 321654987987

Let me know what you think.

Thanks again.


--
ajjag
------------------------------------------------------------------------
ajjag's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35799
View this thread: http://www.excelforum.com/showthread.php?threadid=555717

.

Relevant Pages

  • Re: How much faster is Proc{} bind def with bind ?
    ... %%Creator: Gernot Hoffmann ... /mm def ... mm sx div setlinewidth ... } repeat % 1 ...
    (comp.lang.postscript)
  • Re: How much faster is Proc{} bind def with bind ?
    ... The code in your original posting + patches (DrawHilb0) ran in about ... The code below with partial sums rans in about 700+ ms. ... /g8 0 def ... } repeat % 1 ...
    (comp.lang.postscript)
  • Re: [QUIZ] VCR Program Manager (#101)
    ... thought - oh, can't do lists, no pointers - but then I realized that ... def advance ... new_node.set_next @head ...
    (comp.lang.ruby)
  • Re: is there a better way?
    ... repeat is the number of iteration, ... xcount is the number or non-zero values in the list, ... def with_while: ... res while alist and alist: ...
    (comp.lang.python)
  • Re: is there a better way?
    ... repeat is the number of iteration, ... xcount is the number or non-zero values in the list, ... def with_while: ... return res ...
    (comp.lang.python)