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!