VBA to count the number of entry in a row and update in count column

[swindel]

Hello,

I am new in this forum and would like to understand the VBA macro, Just wanna know how can I count the number of entries in a row per criteria. I have the Unique ID, and have a couple of data and will insert the count on Count Y and Count X.

ID	Data 1	Data 2	Data 3	Data 4	Data 5	Data 6	Count Y	Count X
1​	X	Y	X	X	X		1​	4​
2​	X	X		X			0​	3​
3​		Y	Y	Y			3​	0​
4​	Y	Y	Y	X		X	2​	2​
5​							0​	0​
6​	X		X	Y	Y		1​	2​
7​		Y	Y	Y	X	X	3​	2​

 

[swindel]

Hi Micron,

Thank you for your help, but i dont want to loose this opportunity to ask the function, rs.Fields.Count related to the column, how about if rows to be tested, should it be rs.Rows.Count?

 

[Micron]

I have no idea what you're asking. I gave you code in my last 2 posts, at least one of which should be giving the result you show in your sample data.

 

[jackd]

swindel,

See this link. Why not try the code that's been given to you?

 

[swindel]

Hi Micron,

Yes it did work and i am trying also to understand as well if i will be tested rows instead of column.

 

[Micron]

It is testing the record (row). It's not testing the field (column).