I have a list of items, and I want each item to appear 6 times,
althought now they are just there once, for the last sheet i went to
add row then dragged down what was in the box, but there has to be an
easier way.
Now:
a
b
c
d

What I want:
a
a
a
a
a
a
b
b
b
b
b
b
c
c
c
c
c
c
d
d
d
d
d
d

I am a very new excel user and cannot figure out how to write a macro
or something to do this. please help.

Thanks in advance for any help.


--
CatherineN
------------------------------------------------------------------------
CatherineN's Profile: http://www.excelforum.com/member.php...o&userid=35469
View this thread: http://www.excelforum.com/showthread...hreadid=558649