hi guys,


i have a list of codes like this

FFAE001U
FFAE002U
FFAE003U
FFAE004U
FFAE005U
FFAE006U
FFAE007U
FFAE008U
FFAE009U
FFAE010U

i have 900 alltogether. i need to be able to change this list so that every code is repeated five times like this:

FFAE001U
FFAE001U
FFAE001U
FFAE001U
FFAE001U
FFAE002U
FFAE002U
FFAE002U
FFAE002U
FFAE002U
FFAE003U
FFAE003U
FFAE003U
FFAE003U
FFAE003U


any ideas?????

im using excel 2003!

i did a relative macro, which seems to have done the trick.

easy when u know how.

kids today r probably being taught this b4 they are 10. its not like in my day when you had to type dir to look at a folders contents.

:-)