d2410
12-30-2011, 02:22 AM
Hi,
I am new to VB. Can anyone suggest me a formula or vb script for the following. I have three columns as below
Employee hrs worked in year hrs worked in this month
12345 1000
34556 800
Suppose for this month if i enter 100 hrs for employee 12345,120 hrs for 34556 and so on, the corresponding total no of hrs worked in a year should get automatically upated to 1100,920 for the employee resp.
This should happen for the entire excel for all the employee.
How can this be done?
I am new to VB. Can anyone suggest me a formula or vb script for the following. I have three columns as below
Employee hrs worked in year hrs worked in this month
12345 1000
34556 800
Suppose for this month if i enter 100 hrs for employee 12345,120 hrs for 34556 and so on, the corresponding total no of hrs worked in a year should get automatically upated to 1100,920 for the employee resp.
This should happen for the entire excel for all the employee.
How can this be done?