uclabruwin
03-31-2020, 07:50 PM
Hello All, :hi:
First time in this forum and new to VBA, so I appreciate any help I can get.
Trying to create code for a COUNTIFS function to return values from another worksheet.
The two worksheets being used are:
Central Summary: where my value is to be returned and that has the "text" i want to search in the 2nd worksheet
Central Data: the data sheet i want referenced and counted.
I want the script to return value into Cell C16 of my "Central Summary" worksheet;
I need the code to search column M in my "Central Data" worksheet for text in Cell A23 from the "Central Summary" worksheet, then using that criteria, search the "Central Data" worksheet again for the words "On Hold" in Column A and return the sum of those occurrences.
The current working formula is below
=COUNTIFS('Central Data'!M:M,'Central Summary'!A23,'Central Data'!A:A,"On Hold")
Thank you in advance for all the help.
A.
First time in this forum and new to VBA, so I appreciate any help I can get.
Trying to create code for a COUNTIFS function to return values from another worksheet.
The two worksheets being used are:
Central Summary: where my value is to be returned and that has the "text" i want to search in the 2nd worksheet
Central Data: the data sheet i want referenced and counted.
I want the script to return value into Cell C16 of my "Central Summary" worksheet;
I need the code to search column M in my "Central Data" worksheet for text in Cell A23 from the "Central Summary" worksheet, then using that criteria, search the "Central Data" worksheet again for the words "On Hold" in Column A and return the sum of those occurrences.
The current working formula is below
=COUNTIFS('Central Data'!M:M,'Central Summary'!A23,'Central Data'!A:A,"On Hold")
Thank you in advance for all the help.
A.