Merging Columns based on two criteria. URGENT.

Dear all,.
I'm fairly new to VBA programming.

I would like to merge 7 columns if two conditions are meet.

Start Week Ending week Jan Feb Mar Apr May Jun July Aug Sept Oct Nov Dec
7 11
7 11 12
1 53 1
1 53 1




If the values in the column A is 1 and column B is 53, I want to merge the columns C3 to N3

If the values in the column A is 7 and column B is 11, I want to merge the columns D2 to E2

Is it feasible using VBA programming or Do I have any functions??

Please do help me.

Many thanks!

Regards,
Puppy