Printable View
Desperately need a VBA to read data from first sheet and report result to second sheet. Basically code will count the number of cells that have a non-zero quantity and report result to sheet 2. There are 14 columns in all. Each column is further divided into five different status fields that needs to be individually counted as well. Good luck- Thanks!
here is an explanation in case it is confusing.
The RawDataSheet has 14 columns (D:Q) populated with CONTAINER NUMBERS; if we take the first CONTAINER NUMBER 'IHJo8' in column D for example and filter out both the blank cells and the 0 quantity cells you will be left with the following quantities: 0-VERY GOOD, 2-GOOD, 2-BAD, 1-QUESTIONABLE, 0-NOTRATED. And that is the result that is transfered to ResultSheet Row 2. please let me know if it makes any sense. I am getting desperate for a solution and i am not sure why i am not getting any replies. Thanks.
the first picture is result after the macro is ran.
the second picture is BEFORE Macro is ran.
the third picture shows column D filtered to show the quanitites being counted in the explaination above. thanks.
replies come when members have time to look, also the forum website is performing so poorly it is hard to read threads at all, i could not access at all last nightQuote:
I am getting desperate for a solution and i am not sure why i am not getting any replies.
can you not use a sumif worksheet function in the second sheet
i can not see, from your pictures, where you get your results, though maybe some columns are not visible