Good After Noon, Trust everyone is Good
Preparing a small tool which helps me in Daily routine at my work.
I have a data where i am creating a pivot table and need to report out the numbers to my Team where we stand.
I have written a code so far where pivot table is getting populated with the help of VBA i got stuck and have reviewed so many threads on different forum also gone through several videos still not getting what i need My Pivot data starts from Row 22 till Row 81 it may vary depending on the data. Now as when Data is being added Columns in Pivot is getting added so i need my Formula for Countif =COUNTIF(F23:F78,">7.62") in Cell B5 i have to added Column Number every time F, Next Day G then H , I am looking for some code so can the formula it self do it Cell B11 =COUNTIF(F23:F78,">6.50")-COUNTIF(F23:F78,">7.50")
I Apologies if made any mentors confused and this may be silly query but still i am learning and have learnt little in last couple of years.
Below is the image not fully but it look like this.
Thank You so much
Note : Could of hours back i had raised a query incorrectly on different forum . Just relaised and deleted that one
Preparing a small tool which helps me in Daily routine at my work.
I have a data where i am creating a pivot table and need to report out the numbers to my Team where we stand.
I have written a code so far where pivot table is getting populated with the help of VBA i got stuck and have reviewed so many threads on different forum also gone through several videos still not getting what i need My Pivot data starts from Row 22 till Row 81 it may vary depending on the data. Now as when Data is being added Columns in Pivot is getting added so i need my Formula for Countif =COUNTIF(F23:F78,">7.62") in Cell B5 i have to added Column Number every time F, Next Day G then H , I am looking for some code so can the formula it self do it Cell B11 =COUNTIF(F23:F78,">6.50")-COUNTIF(F23:F78,">7.50")
I Apologies if made any mentors confused and this may be silly query but still i am learning and have learnt little in last couple of years.
Below is the image not fully but it look like this.
Thank You so much
Note : Could of hours back i had raised a query incorrectly on different forum . Just relaised and deleted that one