I have file with macro (I did not code this as I am not yet very familiar with macro) that replicate the details of specific line (Service sheet) based on the number of marks indicated in column F. The output will generated in Output sheet. In column E (Output sheet), the amount will be reflected based on the value indicated on column G (Servicesheet). on the succeeding line on column E, it will add the additional value + the value from column h (service sheet). The macro is working correctly. However, if the value of columns G and H (service sheet) have decimal points, the value in column e (output e) is automatically rounded off by macro. Resulting to incorrect value.
example in Output sheet
E2 is 94 while it should be 94.50
E3 is 188 while it should be 189 (94.50 + 94.50)
E4 is 282 while it should be 283.50
I hope explain my problem clearly.
Bookmarks