Dynamic Columns VBA help needed.

[prasadavasare]

Hi,

In column (A:A) A1="Dates" (Sorted A - Z). For e.g. 1st date is 27-12-2011 and last date is 18-03-2013.
Month Should start from the last 12 month of the 1st date till the last date in above e.g columns should be Jan 11 till Mar 13. Last column should be "Remarks".

C1= Jan 11 D1=Feb 11 E1=Mar 11 F1=Apr 11 G1=May 11.........................till AC1=Mar 13. AD1= Remarks. Please revew the below table for better picture.


Please help with VBA codes to accomplish above.

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE
1	TransID	Dates	Jan11	Feb11	Mar11	Apr11	May11	Jun11	July11	Aug11	Sep11	Oct11	Nov11	Dec11	Jan12	Feb12	Mar12	Apr12	May12	Jun12	Jul12	Aug12	Sept12	Oct12	Nov12	Dec12	Jan13	Feb13	Mar13	Remarks
2	1	27-12-2011
3	2	27-12-2011
4	3	27-12-2011
5	4	27-12-2011
6	5	27-12-2011
7	6	27-12-2011
8	7	27-12-2011
9	8	27-12-2011
10	9	27-12-2011
11	10	27-12-2011
12	11	28-12-2011
13	12	28-12-2011
14	13	28-12-2011
15	14	28-12-2011
16	15	28-12-2011
17	16	28-12-2011
18	17	27-01-2012
19	18	27-02-2012
20	19	27-05-2012
21	20	27-07-2012
22	21	27-08-2012
23	22	27-12-2012
24	23	27-12-2012
25	24	27-12-2012
26	25	27-12-2012
27	26	27-12-2013
28	27	27-12-2013
29	28	27-12-2013
30	29	22-02-2013
31	30	18-03-2013

<tbody>
</tbody>

Thanks & Regards,
Prasad Avasare.

 

[prasadavasare]

Hi,
The first line in my comments should read as In column (B:B) B1="Dates" (Sorted A - Z).

 

[prasadavasare]

Hi,
Somebody please help to resolve this.

Thanks & Warm Regards,
Prasad Avasare.