I have the enclosed report with the periods going horizontally accross
Jan 2014 Feb 2014 MAr 2014 APril 2014 May 2014 June 2014 etc...
A 120.00 200.00 350.00 450.00 650.00
B
C
D
I would like to have the periods go horizontally. How can i do this?
I have the enclosed report with the periods going horizontally accross
Jan 2014 Feb 2014 MAr 2014 APril 2014 May 2014 June 2014 etc...
A 120.00 200.00 350.00 450.00 650.00
B
C
D
I would like to have the periods go horizontally. How can i do this?
meaning you attached the workbook? If so, I think you forgot to attach itI have the enclosed report with the periods going horizontally accross
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Copy(entire range including headers)> Paste Special> Transpose> Okay
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
see attached file.
Did you try Chemist's suggestion?
Entia non sunt multiplicanda sine necessitate
Hey, I just butted into your thread about months and days LOL
it did work thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks