VBA Help

[hoopslogan]

Hi,

I am looking for help in creating a loop for excel file attached. In the file there is a source sheet and a destination sheet. On the destination sheet there are cells highlighted in yellow that need to be filled by data from the source sheet. For example, in row e column 1 of the destination sheet you will see the value A. The proceeding columns for that row need to be filled with the numbers that correspond to A and the right date. So row 3 column 2 value needs to be A for 6/30/2043. I need this done for this entire table. Any suggestions? Thanks!


SOURCE SHEET:

	T1	T2	T3
	6/30/2043	9/30/2043	12/31/2043	3/31/2044	6/30/2044	6/30/2043	9/30/2043	12/31/2043	3/31/2044	6/30/2044	6/30/2043	9/30/2043	12/31/2043	3/31/2044	6/30/2044
Group 1	11094012834.57	11395646234.05	11697885090.24	11684977933.02	12065695232.33	3402575867.80	3214650959.38	3816644628.77	3471326906.44	3662880960.57	88316644.28	82444703.26	96018028.57	92584947.96	84829134.06
A	4518015237.31	4542415237.31	4754765237.31	4879083487.31	5003472852.22	683529468.11	594758665.61	610349219.42	614832479.53	790206283.35	5601265.30	7815120.34	9642315.16	8903154.88	8161113.52
B	3158336817.46	3405669269.52	3420011324.50	3359494677.18	3366086482.77	2242945950.93	2263670874.96	2394991391.98	2234730576.64	2254857030.45	37927447.50	35624983.42	39768996.95	36315345.34	36598169.84
C	1326300000.00	1321334578.30	1329402017.70	1252102017.70	1319602017.70	142173473.63	77590945.27	295207209.18	171822456.40	276175076.67	3327473.33	4556156.65	6371749.34	5103458.31	4676468.06
Group 2	8288742564.29	8885959785.95	9041997973.94	9410590310.60	9782268079.92	5347923545.07	5559431635.03	5382460223.14	5567383491.43	5816841659.32	370271289.47	350633462.38	364963015.08	366391040.67	357369338.89
D	7682341118.52	8293880317.98	8376023521.77	8722486471.30	9098766726.60	5015546696.53	5226968416.07	5033893883.41	5181642029.38	5424872745.42	316588695.54	302413910.58	318965498.12	318472439.71	314187124.72
E	1331314032.89	1573240901.49	1454130025.78	1588672658.00	1664509740.86	906273660.87	896492313.02	697908222.60	598805715.03	627588213.31	6416785.94	8968215.42	11340016.90	12912691.94	10873871.36
F	102962482.05	83291001.26	69100412.04	69512343.92	67197076.75	81947853.63	69426919.40	55901907.24	56121916.10	54063696.52	11560653.28	8367025.83	6049238.45	6973280.48	1843882.75
Group 3	14135992987.73	14784457131.96	14342306229.87	15265568067.76	15728239738.20	7616433236.17	7992070887.18	8073304712.35	8518976461.52	8738685210.80	412129847.47	364006554.59	327190319.12	358456767.55	339003274.23
G	7501758841.84	7998064824.94	7558607148.13	8524891099.82	8866494193.91	2275910640.70	2732110067.39	2599423078.35	3069724498.35	3296406549.87	152013511.43	120880283.09	109197069.41	136504323.35	132910838.60
H	4319804187.84	4452364718.94	4517663359.04	4526811620.81	4721359723.52	3058918670.62	2959282031.87	3239310119.21	3275845690.29	3341870755.36	114789783.14	112981137.71	109793637.92	109616607.16	106842653.91
I	2314429958.05	2334027588.08	2266035722.70	2213865347.13	2140385820.77	2281603924.85	2300678787.92	2234571514.79	2173406272.88	2100407905.57	145326552.90	130145133.78	108199611.80	112335837.05	99249781.72

<colgroup><col><col span="5"><col span="5"><col span="5"></colgroup><tbody>
</tbody>

DESTINATION SHEET:

(Figures in $MM)	6/30/2043	9/30/2043	12/31/2043	3/31/2044	6/30/2044
T1
A
B
C
T2
A
B
C
T3
A
B
C

<colgroup><col><col span="2"><col><col span="2"></colgroup><tbody>
</tbody>

 

[oldbrewer]

either the formatting is scrambled - or I am not seeing what you want

A is in first column so how can there be preceding columns ?

 

[hoopslogan]

Sorry for the confusion I meant to say the columns after that first column. So row 2 column one says A I need the values that correspond to the dates for A from the sourcesheet to be placed in the chart on the destination sheet in the Rows for A based on T1, T2, T3.