Dynamic Columns VBA help needed.

prasadavasare

New Member
Joined
Apr 28, 2011
Messages
45
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.
 
Last edited:

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

Watch MrExcel Video

Forum statistics

Threads
1,123,110
Messages
5,599,776
Members
414,337
Latest member
ogoodheart

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top