I know this shouldn't be fighting me...
Trying to put together o365 VB macro. I have some data. Need to walk each row. Need a count of total rows for each "PRIORITY" (column name) value of 1 thru 4 and the count of each that "Percent Complete" IS NOT "100.00". Want to write these counts on a newly created sheet in the same workbook.
Source data:
Desired output:
I've spent too much time on this and I know I'm missing one small thing. I'd appreciate any solutions from the group. Thank you so much!!!
Steve
Trying to put together o365 VB macro. I have some data. Need to walk each row. Need a count of total rows for each "PRIORITY" (column name) value of 1 thru 4 and the count of each that "Percent Complete" IS NOT "100.00". Want to write these counts on a newly created sheet in the same workbook.
Source data:
Desired output:
I've spent too much time on this and I know I'm missing one small thing. I'd appreciate any solutions from the group. Thank you so much!!!
Steve