Hi All,
I want to use countifs function "Criteria :- Team Lead wise, Recuirter Wise, Month Wise Number of submissions & interview" by the macro coding.the both files attached herewith.
Cooperation will be appreciated.
Vansh Chaudhary
Hi All,
I want to use countifs function "Criteria :- Team Lead wise, Recuirter Wise, Month Wise Number of submissions & interview" by the macro coding.the both files attached herewith.
Cooperation will be appreciated.
Vansh Chaudhary
You need to explain how to convert the raw data into the reporting format.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
i am sending you the example kindly look into this "COUNTIFS([Data.xlsx]CS!$D:$D,$C7,[Data.xlsx]CS!$A:$A,$B7,[Data.xlsx]CS!$C:$C,D$1)" that's i want to do by the macro coding.
Thank you.
Cooperation will be appreciated.
So you only need help with calculating the countifs through macro? Where should this calculation be done?
Yes, the calculation should be from data file as i already attached above.
Ok, but where should the calculated figure be input?
In reporting format file attached above.
Yes, but in which sheet, which cell?
Recruiter Wise Report Sheet "Cell D7 to O7"
You would also need the formula for the rest of the rows right?
Yes, you are right.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks