You would only be able to transpose 245 rows to sheet 15 if you only copy
them so that each column begins on row 1. to get all 2400 rows, for those
sheets that have that many, on sheet 15 it would be necessary to also enter
transposed groups beginning on rows 11, 21, 31, through possibly 101. The
other option would be to use up to 10 new sheets for each old sheet for which
data is transposed. There are only 256 columns across each worksheet. Are
you sure you want to do this?

"Boyd Smith" wrote:

Hi
I am running excel xp on windows xp.
I Have Lots of data on lots of worksheets.All of the data is numbers In 9
cols, A thru I, Most of them have 2400 + rows tho some can be less than 2400
There is No formulas but some of the Cells Have A background color so I need
to keep that.
What Im trying to do is copy seven rows and paste special transpose to sheet
15 A1, Go back get the next seven rows and transpose them to sheet 15 A9
Leaving an empty row ,.Next Seven Rows Transpose to A17 ,Next A25 etc To
The Last Row of the sheet;
In other words Im trying to copy each seven rows on a sheet and transpose
to sheet 15 in the same workbook Leaving An Empty row Beteween each seven
rows
By the way workbook name "Catchall "
I want to repeat this all the way to the last row,
I hope this makes sense to someone that can help me,
Thanks be to all
Oke Doke