The Database Forum

**paulwebmaster** · 09:07 AM

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!

**paulwebmaster** · 11-28-2006, 10:17 AM

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.

:-)