View Single Post
Old 09-09-2009, 06:37 AM
aligahk06 aligahk06 is offline Windows XP Office 2007
Advanced Beginner
Join Date: Aug 2009
Posts: 58
aligahk06 is on a distinguished road
Default Help swaping value from horizontal to vertical.

Dear All,
I want to fetch data from horizontal to vertical .
Data format is c6:j6 total eight values c7:j7 upto c21 to j21 total 128
This 128 values which was placed horizontal i want to pull it into
vertical col.
i.e Range C6:J6 into D1:D8 and C7:J7 into D9:D16 and so on till range
C21to J21 into D... :D ... vertical.
Please assist either macro or Function.

Reply With Quote