Copy and paste tranpose VBA
 

Any help on this code would be greatly appreciated. I think I need a loop or
something but not too sure, I am new at VBA, and learning.

Thany you

"karar" wrote:

I have several summaries of data for the month, each month is has 15
different types of regions, what I would like to do is copy each region at
one time and paste tranpose to the next worksheets

Example:
January
Reg TR Costs
1 123456 123456
2 123456 908765
Feb
Reg TR Costs
1 123456 654789
2 656321 654321

I want it to look like this
Jan Feb
TR 123456 123456
Costs 123456 654789