Excel VBA

[jhedges]

Excel Workbook
	A	F	G	K	L	M	N	O	S	U
1	STATUS	STAFF	MEMBERSHIP TYPE	EXPIRATION DATE	DOOR ACCESS	SAFETY ORIENTATION	EQUIPMENT ORIENTATION	PAYROLL FORM	PENDING	CANCELED
2	EXPIRED	NM	BRB	06/08/08	Y	Y	Y	Y		N
3	ACTIVE	JH	BRB		Y	Y	Y	Y		N
4	ACTIVE	JH	BRB		Y	Y	Y	Y		N
5	EXPIRED	NM	BRB	11/08/08	Y	Y	Y	N		N
6	ACTIVE	JH	BRB		Y	Y	Y	Y		N
7	ACTIVE	NM	BRB	06/13/12	Y	Y	Y	Y		N
8	INACTIVE	JH	BRB		N	Y	Y	Y		Y
9	ACTIVE	JH	BRB		Y	Y	Y	Y		N
10		JH	F&HCIC		Y	Y	Y	N		N
BRTC Database

 

[VoG]

You haven't asked a question.

 

[jhedges]

Thanks for responding - I was in the middle of 10 different things and accidently hit the submit versus preview, then got side-tracked again.

My spreadhseet is A1:Y190 setup as a table and will grow in rows.

I included some of the columns in the initial post along with the formulas.

I am trying to make the column A rows change based upon how the data is entered and was trying formulas; however, have ran into limitations and was thinking VBA could help; however, I'm not sure how to create code in VBA and would appreciate some help:

If Membership Type(G) = "BRB":
Looking at columns L,M,N,O as all = "Y", Not expired(K), Pending(S) <> "pending" and Cancelled(U) = "N" then display "ACTIVE".

If LMNO have "N" in any of the columns with the above criteria, then display "WARNING".

Regardless of the above:
If Expired(K), then display "EXPIRED"

If Pending(S), then display "PENDING"

If Cancelled(U), then display "INACTIVE"

If Membership Type(G) <> "BRB", but equal to "F&HCIC", "GO", "MBC", "MVIC" or "WHBC":
Looking at columns L,M,N as all = "Y", O="N", Not expired(K), Pending(S) <> "pending" and Cancelled(U) = "N" then display "ACTIVE".

If L,M,N have "N" in any of the columns with the above criteria, then display "WARNING".

Regardless of the above:
If Expired(K), then display "EXPIRED"

If Pending(S), then display "PENDING"

If Cancelled(U), then display "INACTIVE"

 

[jhedges]

Just wondering if anyone has any helpful information on my question?