View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
karar karar is offline
external usenet poster
 
Posts: 2
Default Copy and paste tranpose

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