Calculation Question

[thescream80]

Hello,

I am building a worksheet that I will need to get data from. The question is how can I write a code so that it can pull data by date.

For Example on the main Sheet

A--------B-----------C
1/1/19 - Job1234 - COMPLETE
1/1/19 - Job5678 - Not Complete
2/1/19 - Job9012 - COMPLETE
2/1/19 - Job3456 - Not Complete

Now on another sheet have it calculate - Total Jobs / Total Complete by date



January = 50%
February = 50%

I hope that makes sense. Thank you for any help on this!

 

[arthurbr]

Perfect job for a Pivot Table

 

[thescream80]

Thank you. Never have tried a pivot table. I can see if I can watch some videos on how to do that. Is it because of the desire to filter by date range that makes just writing a code to difficult?

Thanks again!

 

[arthurbr]

Have a look at https://www.contextures.com/CreatePivotTable.html