Display columns in excel based on Data validation list in multiple columns

Hi,

I have the below code which hides columns based on a Data Validation List in Column A. I need to add another Data Validation in Column B. So it would be if a value is selected from Column A and Column B only display certain columns.

How it would need to work is based on the below logic:

If Column A = 5 and Column B = Yes - then show the columns per the below code.
If Column A = 5 and Column B = No - then only show the following Columns C, II:IN, IV:IW, JD:JE, JL:JM

If Column A = 6 and Column B = Yes - then show the columns per the below code.
If Column A = 6 and Column B = No - then only show the following Columns C, AR:AW, CS:DX, DY:EX, EY:FB, FI:FJ, FQ:FR, FY:FZ, GG:IG

If Column A = 7 and Column B = Yes - then show the columns per the below code.
If Column A = 7 and Column B = No - then only show the following Columns C, AR:AW, BL:BM, BV:BW, CC:CD, CK:CL, DY:EX, EY:FB, FI:FJ, FQ:FR, FY:FZ, GG:IG

How would I work it into the below code?

Please Login or Register  to view this content.

thanks. Was able to add to the code to get what wanted.

Appreciate the help.