A
arectoo
Hi, I have a resource pool with over 2k employees and I need to update
Cost Rate Table B.
The rates used in the Cost Rate Tables are determined by the each
resource's code (stored in the resource Code field). There are about
100 total codes and no Overtime or Per Use Cost fields. Following is
an example of a resource code with its rates.
Code = 1.ABC
With effective date = current
Standard Rate = $50/h
With effective date = 1/1/08
Standard Rate = $52/h
With effective date = 1/1/09
Standard Rate = $53/h
So, if
Resource name = Joe
Code = 1.ABC
I need to enter the rates for 1.ABC into Cost Rate Table B.
Can someone please assist with some starter VBA code to accomplish
this? I am new to VB.
Thank you for any guidance!
Cost Rate Table B.
The rates used in the Cost Rate Tables are determined by the each
resource's code (stored in the resource Code field). There are about
100 total codes and no Overtime or Per Use Cost fields. Following is
an example of a resource code with its rates.
Code = 1.ABC
With effective date = current
Standard Rate = $50/h
With effective date = 1/1/08
Standard Rate = $52/h
With effective date = 1/1/09
Standard Rate = $53/h
So, if
Resource name = Joe
Code = 1.ABC
I need to enter the rates for 1.ABC into Cost Rate Table B.
Can someone please assist with some starter VBA code to accomplish
this? I am new to VB.
Thank you for any guidance!