Countifs Function in VBA

[Abhijeet]

Hi

I want to use macro for Countifs function i use formula but i need macro for this
please help me

Formula is use this =COUNTIFS('Process Data'!$A:$A,Tally!$A3,'Process Data'!$C:$C,Tally!$B3,'Process Data'!$H:$H,Tally!C$2)

i need in Sheet 3 Range C3:H5 & J3:N5 please tell me

 

[Abhijeet]

This is not Cross post file is look like same but no one is give full Ans so i post again & one of the member told me post new thread

 

[NARAYANK991]

Hi Abhijeet ,

I have a macro in this file which creates a SUMIFS formula ; I am sure you can modify this to cater to a COUNTIFS formula. I am sorry but I cannot help in this modification.

Narayan

 

[Abhijeet]

Thanks for file I Done with my requirement and also thanks for u hope i will do this

 

[Abhijeet]

Hi

I need help in Column I & O & X & Y & Z i use formula i need to put this macro then Column Z all true and false data pull in different sheets
Copy Column A to V only in both sheets

I used auto filter but unable to do this