I want to create a macro that counts like the following:
Column A: Structure
Column B: Quantity of poles
Column C: Pole class (range from 1 to 10)
Column D: Pole Height (range from 50 to 140)
For example
1 2 1 100 means structure 2 have 2 class 1 - 100' poles,
2 3 1 100
3 2 5 90
Result:
5 1 100 (*Note :5 Class 1 - 100' poles)
2 5 90 (2 Class 5 - 90' poles)
I have also attached an excel spreadsheet using the record macro tool to did some calculation, but it can only perform count by entering each set of data one at a time, so I'm working on the loop function that using this strategy, it gives me error. And I'm stuck, please help. I appreciate all your effort. Thank you very much.
Bookmarks