Hi All ,

Can some one help me with a macro that gives count for number of entries in column A , B and C for Tables/sets of data

My data is divided into Tables/sets. A Table/Set of data is from one entry in D column to the next entry.


I have 4 columns A , B , C , D . I want to find out the count of records in each column for that data set .

In column A : Blank rows and Rows which contain the string "variation" , "(" and ")" parenthesis should not be taken into count
In column B : Blank rows and rows which contain the string "detected" should not be taken into count
In column C : Blank rows and rows which contain the string "item_name" should not be taken into count

The count for column A will be populated in column E
the count for column B will be populated in column F
the count for column C will be populated in column G

I am new to VBA so it would be of great help if some one could help me out.

Attached is Sample data where I have given my desired output in columns E , F , G for the first 3 sets


Sample_Data.xlsx

Thanks in advance