Calculating between 2 worksheets
Hello,
I have NEVER done calculations using VBA and am pretty new to this world but always eager to learn, and I am need of some help. I have a worksheet called "Wheels Trans" which has a table of data and it also has 3 columns called "DAYS CHARGED", WEEKS CHARGED", "MONTHS CHARGED".
DAYS CHARGED |
WEEKS CHARGED |
MONTHS CHARGED |
Comm Amt to Charge |
I have a file in another tab called "Tier"
Tier |
Millions |
Daily |
Monthly |
I |
0-$15 |
9.08 |
230.00 |
II |
$15+ |
15.14 |
232.50 |
In the "Comm Amt to Charge" column, I would like the calculation as follows: Looking at row 2 of table 1, MONTH CHARGED is 1) so i would like to have the calculation (1*230.00). The DAYS CHARGED with 1 would be (1*9.08) and the CHARGED WEEKS with 3 would be (3*7 = 21 which is converted to days) and then multiplied by 9.08. I hope this makes sense. I would like if it would loop until the last row. I want it to ignore the 0s and calculate all that have values.
Any help is appreciated.