Arnolf
10-20-2005, 07:29 PM
Hi,
Before, I have to confess that I already asked this question in other Boards, unfortunately without any answer. Hope you can help me.
I need via Worksheet_Change event VBA code insert (copy) new columns or delete them based on the max value of month/year (sum of date and month).
Example: (I enclose my file 900125.xls)
I have in D9 :11 and F9:F11 my dates and months.
The sum for the first one is June/2005 + 3 months = Aug/2005
The second one May/2005 + 1 month = May/2005
Third one June/2005 + 2 months = July /2005
The max value is Aug/2005. So, the macro should show the month columns to Aug/2005.
In mi example, I only have until July/2005, so it should insert a new column Aug/2005 with all the formats of column July/2005.
If the maximum value would be June/2005, the macro should delete column July/2005.
My date range goes grom row 9 to row 1500+
Thank you in advance sirs for your help.
Before, I have to confess that I already asked this question in other Boards, unfortunately without any answer. Hope you can help me.
I need via Worksheet_Change event VBA code insert (copy) new columns or delete them based on the max value of month/year (sum of date and month).
Example: (I enclose my file 900125.xls)
I have in D9 :11 and F9:F11 my dates and months.
The sum for the first one is June/2005 + 3 months = Aug/2005
The second one May/2005 + 1 month = May/2005
Third one June/2005 + 2 months = July /2005
The max value is Aug/2005. So, the macro should show the month columns to Aug/2005.
In mi example, I only have until July/2005, so it should insert a new column Aug/2005 with all the formats of column July/2005.
If the maximum value would be June/2005, the macro should delete column July/2005.
My date range goes grom row 9 to row 1500+
Thank you in advance sirs for your help.