passing arguments and getting count in cells in vba

[silverblade]

I have the below code where the count of a cell gets updated based on a search from a specific column, specific text and specific worksheet.

How do I pass argument such that when it meets the condition, the count should be updated in the designated cell?

Currently thecodes just goes to the worksheet mentioned and scans a column for a specific string and if it matches, it will give the total count of the matched row in the designated cell. So I need to apply the same code to 30+ cells to perform this task (with diff strings as the search conditions in diff sheets). If the above code can be converted into hash with arguments (arguments being the sheet name, text to search,range to place the count, col to search) and when the arguments (the string here) meets the condition, the count should be updated in the designated cell.

Please Login or Register  to view this content.

[AlphaFrog]

So I need to apply the same code to 30+ cells to perform this task (with diff strings as the search conditions in diff sheets).

It helps to give specifics. Where are the 30+ sheet names, search criteria, and output cells? Perhaps an example workbook would help.

[silverblade]

I have attached a excel.

*The "Main" sheet is where the count is updated. THe strings are searched from other sheets in the workbook.

* The cells where the count should be updated varies. I will just add the necessary cells.

*The search criteria,keyword,sheet,range, etc is given in the sample code which I have posted.

Exfrom code)

In Cell, AE43, the count is updated only when the sheet "TT" meets the criteria mentioned.

So, similarly I'll have to use the same kind of code 30+ times for different cells to get the data.

Instead of this, If I could pass arguments (sheet name,cell range,searchtext,col name) and hash it, I can achieve this in a single subroutine or multiple subroutines.

[AlphaFrog]

Instead of this, If I could pass arguments (sheet name,cell range,searchtext,col name) and hash it, I can achieve this in a single subroutine or multiple subroutines.

Not sure what "hash it" means. I'm trying to understand what form the source arguments will take?

[silverblade]

I just saw somewhere that there is a "dictionary" function in vba that does the job of "hashing" .

I'm trying to understand what form the source arguments will take? - Sheetname will always be the same sheet name from the file uploaded,search text will also be the same text..the same applies for other arguments also..

I just told what I had in my mind. If you have a better idea to prevent repetitive code, please suggest.

[silverblade]

Any suggestions?