Nicole_Michelle01
Board Regular
- Joined
- Nov 9, 2005
- Messages
- 50
What would the macro look like that would transpose every 14 rows from one worksheet into 14 columns on another worksheet.
Here's the process manually:
- From Worksheet1, select every 14 rows, Copy
- To Worksheet2, in ColumnA first cell in the next empty row, Paste Special, select Transpose
Thanks! ~ Nicole
Here's the process manually:
- From Worksheet1, select every 14 rows, Copy
- To Worksheet2, in ColumnA first cell in the next empty row, Paste Special, select Transpose
Thanks! ~ Nicole