I am trying to create a quick and dirty Serial Number list to load into Avery.

I need to create a serial number list that goes something will repeat the
same line 4 times (Cell A1:A4) and then move up sequentially in Cells A5:A8,
without having to manually type it in, ie:

A001
A001
A001
A001
A002
A002
A002
A002
A003
etc
Any and all help would be greatly appreciated, thanks!

Rowf,

A1 = A001
A2 = A002
Select both cells and drag down as far as you want to go.
Select all the cells in your list and copy them to the cell below the last
one.
Copy and paste twice more.
Your list will look something like:
A001
....
....
A099
A001
....
....
A099
A001
....
....
A099
A001
....
....
A099

Now select all the cells in the list and Sort them.

Henry

"Rowf" wrote in message
...
I am trying to create a quick and dirty Serial Number list to load into
Avery.

I need to create a serial number list that goes something will repeat the
same line 4 times (Cell A1:A4) and then move up sequentially in Cells
A5:A8,
without having to manually type it in, ie:

A001
A001
A001
A001
A002
A002
A002
A002
A003
etc
Any and all help would be greatly appreciated, thanks!

One more way:

="A"&TEXT(INT((ROW()-1)/4)+1,"000")
in A1 and drag down.

Rowf wrote:

I am trying to create a quick and dirty Serial Number list to load into Avery.

I need to create a serial number list that goes something will repeat the
same line 4 times (Cell A1:A4) and then move up sequentially in Cells A5:A8,
without having to manually type it in, ie:

A001
A001
A001
A001
A002
A002
A002
A002
A003
etc
Any and all help would be greatly appreciated, thanks!

--

Dave Peterson