Count the sum of multiply values in one cell, registered as partof a textcode, combine them per column and show the results in the next sheet
Hello Claus, THANKS !!!!
The Code2 works well for me !.
A few remarks that perhaps you can solve in it.
1) If a specific column has no data in at least one of the records below, then the macro stops with an error.
It seems that an empty column is not skipped from the code (no data in record 6 till last used).
2) If a specific column has only data in record 6, then te macro stops with an error.
It seems that the code looks from record 7 and further instead of record 6 and further.
Just for sure..... There should be no limit in the amount of records and columns used. (In pratical I think the max I will use is 5000 records and till column DA).
Regards, Johan
|