I actually expected as much! however, with the info at hand, it is
impossible to quote a macro to do the job for you! I need to know where you
are copying from, I need to know where you are transposing to! I need to
know what you are trying to achieve. What do you mean by the next column
below? Do you want to copy data in rows, and transpose them into columns, or
do you actually want to copy data in a column, and put it into rows?
It is also not clear whether you want to start pasting in say A1:E1, then
the next 5 in B2:F2, or in A2:E2. Or is it that you want to paste in A1:A5,
then B2:B6, or what?
The only way to hasten this process is through a macro, but then you have to
be able to tell the computer exactly what to do!

--
HTH

Kassie

Replace xxx with hotmail


"Imperial" wrote:

Kassie appreciate the response however I assume that; but I have over 2300
cells in a row copying 5 cells at a time would take all day.

"Kassie" wrote:

Iso copying 10 cells in a row, just copy 5.

--
HTH

Kassie

Replace xxx with hotmail


"Imperial" wrote:

I have text in rows that are in separate cells that Im trying to convert
into columns; which I figure out how to do by copying the rows click on the
cell and in the paste special box I then checking off transpose which lays
the copied rows into columns. Now what Im trying to do is the same thing;
however I want to be able to have lets say 10 cells that I copy in a row this
time when it puts into columns I only want 5 cells in that column and the
next 5 cells of the 10 copied I want it to go in the next column below. What
its doing with the 10 cells that I copied in the rows now when I transpose
them into a column is putting all 10 copies cells into 1 column which Im
trying to split the 10 cell rows into 2 columns and so on. Its got to be a
format or formula thing just unsure how to go about this. If someone could
help me with this it would be greatly appreciated. Hope I was good in
explaining.