gvijaygadde
New Member
- Joined
- Oct 14, 2009
- Messages
- 1
Hi,
I am trying to write VBA code for my Excel sheet project management sheet.
Example like this: In Column
A1 - Project start date
B1 - Project end date
C1 - Number of days between these two dates - got the formula
Range("A3").Value = DateDiff("d", Range("A1").Value, Range("A2").Value)
D1 - Number of weeks between these two dates
Range("A4").Value = DateDiff("w", Range("A1").Value, Range("A2").Value)
But now my problem, when start adding dates in next rows the above steps on [C2, D2] [C3,D3] should automatically happend fill the values in based on [A2,B2], [A3,B3] respective colums
How can i automatically incriment the Cell referance value.
Many thanks for your and I really appritiate a quick response on this.
Thanks in advance,
Regards,VJAY.
I am trying to write VBA code for my Excel sheet project management sheet.
Example like this: In Column
A1 - Project start date
B1 - Project end date
C1 - Number of days between these two dates - got the formula
Range("A3").Value = DateDiff("d", Range("A1").Value, Range("A2").Value)
D1 - Number of weeks between these two dates
Range("A4").Value = DateDiff("w", Range("A1").Value, Range("A2").Value)
But now my problem, when start adding dates in next rows the above steps on [C2, D2] [C3,D3] should automatically happend fill the values in based on [A2,B2], [A3,B3] respective colums
How can i automatically incriment the Cell referance value.
Many thanks for your and I really appritiate a quick response on this.
Thanks in advance,
Regards,VJAY.