Macro to transpose rows to columns

B

bradyj7

Board Regular
Joined
Mar 2, 2011
Messages
106
Hi there,

I have to transpose rows to columns in 100s of sheets. Would anyone have a macro handy to to this? The number of columns are fixed (A-N) but the number of rows varies from sheet to sheet.

Thank you

John
 

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
Sort by date Sort by votes
What version of Excel are you using? If before 2007, then if there are more than 255 rows, this might cause problems
 
Upvote 0
Hi,

I'm using 2007, the number of rows is always such that it will never reach the 16,000 or so column limit.

John
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Identifying Groups of Data in a Column, Transposing Groups to a Row
Replies
3
Views
221
KRice
K
Q
  • Question Question
Macro needed to insert 4 rows in table, copy data from above, copy data from another sheet and paste special (transpose values) to those new rows...re
Replies
1
Views
383
sijpie
sijpie
S
  • Question Question
Dynamic Address by VBA
Replies
8
Views
206
MikeVol
MikeVol
C
  • Question Question
Transpose multiple columns to a single column
Replies
1
Views
118
Fluff
Fluff
C
  • Solved
Transposing Columns to Rows
2
Replies
10
Views
271
Fluff
Fluff

Forum statistics

Threads
1,224,602
Messages
6,179,844
Members
452,948
Latest member
UsmanAli786

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top