Spoke to soon. It does repeat but I need those even numbered cells to go
away and move up the information in column A. For example:

APPLE
12465896432131 ABC
BANANA
12345678954321 DEF
CARROT
12345687931 GHI
DOG
1235468895461 JKL

BECOMES:
APPLE 12465896432131 ABC 12465896432131
BANANA 12345678954321 DEF 12345678954321
CARROT 12345687931 GHI 12345687931
DOG 1235468895461 JKL 1235468895461

THANK YOU THANK YOU THANK YOU

This will make my life much easier :)


--
ajjag
------------------------------------------------------------------------
ajjag's Profile: http://www.excelforum.com/member.php...o&userid=35799
View this thread: http://www.excelforum.com/showthread...hreadid=555717