Hi there,
It would be very kind of you if you had any solution to this problem
:
In the A Colomn I have months over differents years
In the B Colomn I have related turnovers
In C1 I have a list made out of the different months (Jan-10, Feb-10, ..., Mar-13)
I want that when you select a month-year from the list (let`s say March-11) it summs Year-to-date related turnovers (here:from March to dec-11)
My code:
Sub Producttype()
Dim i, j As Long
i = 0
j = 0
Do
i = i + 1
j = j + Cells(i, 2)
Loop Until Cells(i, 1) = "" Or Year(i, 1) > Year(1, 3)
Cells(10, 15) = j
End Sub
The proble seems to be that I can not call a date in this format>>>
Pleeeaaaase heeeelp
Bob
It would be very kind of you if you had any solution to this problem
:In the A Colomn I have months over differents years
In the B Colomn I have related turnovers
In C1 I have a list made out of the different months (Jan-10, Feb-10, ..., Mar-13)
I want that when you select a month-year from the list (let`s say March-11) it summs Year-to-date related turnovers (here:from March to dec-11)
My code:
Sub Producttype()
Dim i, j As Long
i = 0
j = 0
Do
i = i + 1
j = j + Cells(i, 2)
Loop Until Cells(i, 1) = "" Or Year(i, 1) > Year(1, 3)
Cells(10, 15) = j
End Sub
The proble seems to be that I can not call a date in this format>>>
Pleeeaaaase heeeelp
Bob
