copying down

[buggy2]

I need to create and column of values starting off at A1 doing down to A10. five times over.

e.g. A1
A2
.
.
.
A10
A1
A2
etc

They should all be in column E. I have a feeling I could be missing something easy.

 

[Juan Pablo González]

Do you need the TEXT A1, A2, ..., A10 ? or a reference to those cells ?

 

[buggy2]

text

A1
A2
A3
.
.
.
.
A10
A1
A2
.
.
.
A10

 

[buggy2]

also it is part of a proceedure so

 

[Juan Pablo González]

also it is part of a proceedure so

I don't know what you mean by this, but put this in a cell, and drag it down:

="A"&MOD(ROW(A1)-1,10)+1

 

[buggy2]

I mean is has to be in a standard module, the piece A01....is a tag for a weight, it has to be set this way I have no choice, it be done alot easier but....

What I actually need is A01
A02
.
.
.
A10
A01
.
.
etc

 

[Juan Pablo González]

="A"&TEXT(MOD(ROW(A1)-1,10)+1,"00")