prakashjoshi87
New Member
- Joined
- Jun 9, 2015
- Messages
- 11
Hi Guys,
I have a value in B2 and and i want to do total of this value on C2 and D2 Format like this
DAY WEEK MONTH
IF I FILL 50 IN DAY CELL THEN WEEK WILL BE 50 MONTH ALSO WILL BE 50 After that i change value in day 10 than Week value auto calculate 50+10=60 and month value also 60
hope you understand.
Please suggest some formulas or vb code.
I have a value in B2 and and i want to do total of this value on C2 and D2 Format like this
DAY WEEK MONTH
IF I FILL 50 IN DAY CELL THEN WEEK WILL BE 50 MONTH ALSO WILL BE 50 After that i change value in day 10 than Week value auto calculate 50+10=60 and month value also 60
hope you understand.
Please suggest some formulas or vb code.