Need assistance with a Macro

[whynot]

I have several spreadsheets with data that is in sequential columns: 1Q04,1Q05,1Q06,1Q07,1Q08.......,2Q04,2Q05,2Q06,2Q07,2Q08.....,3Q04,3Q05,3Q06,3Q07,3Q08.....,4Q04,4Q05,4Q06,4Q07,4Q08....,2004,2005,2006,2007,2008
I would like them in order in a year: 1Q04,2Q04,3Q04,4Q04,2004.....

Thank you.

KELYA 1.0.xlsx
	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM
14	1Q05	1Q06	1Q07	1Q08	1Q09	1Q10	1Q11	1Q12	1Q13	1Q14	1Q15	1Q16	1Q17	1Q18	1Q19	1Q20	1Q21	1Q22	2Q05	2Q06	2Q07	2Q08	2Q09	2Q10	2Q11	2Q12	2Q13	2Q14	2Q15	2Q16	2Q17	2Q18	2Q19	2Q20	2Q21	2Q22E	3Q05	3Q06	3Q07	3Q08	3Q09	3Q10	3Q11	3Q12	3Q13	3Q14	3Q15	3Q16	3Q17	3Q18	3Q19	3Q20	3Q21	3Q22E	4Q05	4Q06	4Q07	4Q08	4Q09	4Q10	4Q11	4Q12	4Q13	4Q14	4Q15	4Q16	4Q17	4Q18	4Q19	4Q20	4Q21	4Q22E	2005	2006	2007	2008	2009	2010	2011	2012
15
16	$1,249.335	$1,360.089	$1,350.858	$1,393.975	$1,043.00	$1,130.40	$1,339.10	$1,354.80	$1,314.80	$1,330.80	$1,320.60	$1,349.10	$1,289.70	$1,369.90	$1,382.60	$1,261.10	$1,205.90	$1,296.40	$1,311.904	$1,416.409	$1,415.674	$1,455.847	$1,028.90	$1,209.40	$1,405.80	$1,366.10	$1,366.90	$1,410.50	$1,385.00	$1,375.50	$1,333.60	$1,386.90	$1,382.60	$975.30	$1,258.10	$1,294.53	$1,344.64	$1,418.80	$1,425.30	$1,397.800	$1,049.20	$1,284.70	$1,409.80	$1,354.20	$1,345.60	$1,396.40	$1,351.00	$1,247.80	$1,328.80	$1,342.40	$1,267.70	$1,038.20	$1,195.40	$1,269.73	$1,383.94	$1,421.38	$1,475.74	$1,279.10	$1,202.60	$1,325.80	$1,396.30	$1,375.40	$1,385.80	$1,425.00	$1,461.80	$1,304.40	$1,422.30	$1,414.70	$1,337.80	$1,241.40	$1,250.30	$1,345.39	$5,289.83	$5,616.68	$5,667.57	$5,526.72	$4,323.70	$4,950.30	$5,551.00	$5,450.50
17	7.8%	8.9%	-0.7%	3.2%	-25.2%	8.4%	18.5%	1.2%	-3.0%	1.2%	-0.8%	2.2%	-4.4%	6.2%	0.9%	-8.8%	-5.5%	7.0%	7.1%	8.0%	-0.1%	2.8%	-29.3%	17.5%	16.2%	-2.8%	0.1%	3.2%	-1.8%	-0.7%	-3.0%	4.0%	-0.3%	-29.5%	29.0%	2.9%	8.0%	5.5%	0.6%	-1.9%	-24.9%	22.4%	9.7%	-3.9%	-0.6%	3.8%	-3.3%	-7.6%	6.5%	1.0%	-5.6%	-18.1%	19.0%	6.2%	2.1%	2.7%	3.8%	-13.3%	-6.0%	10.2%	5.3%	-1.5%	0.8%	2.8%	2.6%	-10.8%	9.0%	-0.5%	-5.4%	-7.2%	0.7%	7.6%	6.1%	6.2%	0.9%	-2.5%	-21.8%	14.5%	12.1%	-1.8%
18
19	($1,045.251)	($1,140.727)	($1,121.650)	($1,138.557)	($867.10)	($950.40)	($1,125.40)	($1,131.10)	($1,097.90)	($1,108.50)	($1,100.30)	($1,116.40)	($1,058.10)	($1,131.70)	($1,131.00)	($1,037.80)	($992.60)	($1,037.80)	($1,097.802)	($1,186.186)	($1,166.108)	($1,194.605)	($857.20)	($1,018.50)	($1,183.70)	($1,142.90)	($1,146.20)	($1,182.40)	($1,162.70)	($1,145.00)	($1,104.80)	($1,146.40)	($1,138.60)	($786.10)	($1,027.10)	($1,038.21)	($1,126.466)	($1,180.207)	($1,176.919)	($1,152.032)	($883.00)	($1,077.50)	($1,181.20)	($1,126.70)	($1,125.20)	($1,171.00)	($1,122.80)	($1,032.70)	($1,098.10)	($1,103.30)	($1,040.00)	($847.20)	($966.50)	($1,015.78)	($1,161.412)	($1,181.884)	($1,209.323)	($1,054.445)	($1,005.80)	($1,109.40)	($1,169.10)	($1,153.20)	($1,154.30)	($1,192.40)	($1,212.10)	($1,076.40)	($1,159.30)	($1,160.30)	($1,092.70)	($1,017.30)	($1,004.30)	($1,089.77)	($4,430.93)	($4,689.00)	($4,674.00)	($4,539.64)	($3,613.10)	($4,155.80)	($4,659.40)	($4,553.90)
Quarterly Model

Cell Formulas
Range	Formula
L16:Q16,S16:W16	L16	='Quarterly Segment'!D45
AC16	AC16	='new segment breakdown'!O137
AD16:AH16,AL16:AM16	AD16	='Quarterly Segment'!T45
AU16	AU16	='new segment breakdown'!P137
AV16:AY16,BG16,BE16	AV16	='Quarterly Segment'!AJ45
BM16	BM16	='new segment breakdown'!Q137
BN16:BR16,BX16,BU16	BN16	='Quarterly Segment'!AZ45
CE16	CE16	='new segment breakdown'!R137
CF16:CH16,CJ16:CM16,CF19:CH19,CJ19:CM19	CF16	=L16+AD16+AV1 KELYA 1.0.xlsx B C D E F G H I J K 14 1Q03 2Q03 3Q03 4Q03 2003 1Q04 2Q04 3Q04 4Q04 2004 15 16 $1,003.397 $1,059.517 $1,097.27 $1,164.97 $4,325.16 $1,158.811 $1,224.464 $1,244.85 $1,355.92 $4,984.05 17 15.5% 15.6% 13.5% 16.4% 15.2% 18 19 ($837.845) ($887.113) ($924.661) ($978.905) ($3,628.52) ($975.455) ($1,026.382) ($1,042.486) ($1,141.222) ($4,185.55) 20 83.5% 83.7% 84.3% 84.0% 83.9% 84.2% 83.8% 83.7% 84.2% 84.0% 21 16.4% 15.7% 12.7% 16.6% 15.4% 22 23 $165.55 $172.40 $172.607 $186.068 $696.63 $183.36 $198.08 $202.368 $214.700 $798.51 24 16.5% 16.3% 15.7% 16.0% 16.1% 15.8% 16.2% 16.3% 15.8% 16.0% 25 10.8% 14.9% 17.2% 15.4% 14.6% 26 27 ($165.162) ($169.955) ($169.898) ($182.879) ($687.89) ($181.342) ($189.404) ($189.908) ($202.359) ($763.01) 28 16.5% 16.0% 15.5% 15.7% 15.9% 15.6% 15.5% 15.3% 14.9% 15.3% 29 9.8% 11.4% 11.8% 10.7% 10.9% 30 Quarterly Model Cell Formulas Range Formula B16 B16 ='Quarterly Segment'!B45 C16 C16 ='Quarterly Segment'!R45 D16 D16 ='Quarterly Segment'!AH45 E16 E16 ='Quarterly Segment'!AX45 F16,K27,F27,K23,F23,K19,F19,K16 F16 =B16+C16+D16+E16 G16 G16 ='Quarterly Segment'!C45 H16 H16 ='Quarterly Segment'!S45 I16 I16 ='Quarterly Segment'!AI45 J16 J16 ='Quarterly Segment'!AY45 G17:K17 G17 =G16/B16-1 B20:K20 B20 =-B19/B16 G21:K21,G29:K29,G25:K25 G21 =G19/B19-1 B23:E23,G23:J23 B23 =B16+B19 B24:K24 B24 =B23/B16 B28:K28 B28 =-B27/B16 6+BN16
CI16,CI19	CI16	=O16+AY16+AG16+BQ16
L17	L17	=L16/G16-1
M17:AA17,BO17:CD17,CG17:CM17,AE17:AT17,AW17,AY17:BK17	M17	=M16/L16-1
AD17	AD17	=AD16/H16-1
AU17,BM17,CE17	AU17	=+(AU16-AT16)/AT16
AV17	AV17	=AV16/I16-1
AX17	AX17	=AX16/AE16-1
BN17	BN17	=BN16/J16-1
CF17	CF17	=CF16/K16-1
AF19	AF19	=-1168.108+2
AR19	AR19	=AR23-AR16
AU19,CE19,BM19	AU19	=AU20*-AU16
AX19	AX19	=-1178.419+1.5
AY19	AY19	=-1152.032
BP19	BP19	=-1210.323+1

 

[Fluff]

Duplicate to: Can A Macro Solve This Problem

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread. If you do not receive a response, you can "bump" it by replying to it yourself, though we advise you to wait 24 hours before doing so, and not to bump a thread more than once a day.