i would like to give credits to those who have 20 or above as the average and with 2 or more categories. those with 2 or more get 15 multiplied by the no of tons while more than 2 categories get 20 multiplied by the no of tons. i will not know the exact no of records every day. i got this an example of loop and case
Sub TheSelectCase2()
Dim i As Single
For i = 1
Do While i < 100
Cells(i, 1) = i
i = i + 1
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum