Dear Expert,
in my worksheet i want to do few calculation by vba code.
My calculation as below:
1. if N6:P6 any data match with "yes" then BO6 should "Embellishment" other "No Embellishment".
2. =SUM(AI6:AJ6) at BP6
3. =IF(AND(BP6>=0,BP6<=4.5),"A",IF(AND(BP6>=4.51,BP6<=7.5),"B",IF(AND(BP6>=7.51,BP6<=15),"C",IF(AND(BP6>=15.1,BP6<=28),"D",IF(BP6<=28.1,"E"))))) at BQ6
4. =IF(BL6-(INT((BL6-1)/7)*7+1)>5,(INT((BL6-1)/7)*7+1),(INT((BL6-1)/7)*7+1)-7) at BR6
5. =AO6*Z6 at BS6
6. =AN6*Z6 at BT6
7. =AI6*Z6/60 at BU6
8. =AJ6*Z6/60 at BV6
All calculation should be calculated for all row on respective column that contains data means like 6. AN6*Z6 at BT6 and also should AN7*Z7 at BT7 and more all row in this column which contains data not blank . (in a column calculation should go up to available data range)
Please help me to get the code.
Best Regards
Wahid
Bookmarks