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
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