Merging Columns based on two criteria

[puppy26]

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​

 

[Legacy 143009]

Do you want to merge like A3+B3+C3=N3?

 

[puppy26]

No.. I want to merge A3: N3 and make it as one cell.

Many thanks for your kind help.

 

[Legacy 143009]

Is M3 OK for as the merging target?

 

[puppy26]

Flashbond,
Just to give you more information, the number distribution in the columns are based on weeks. If the value in the start week is between 1-4, the merging should start from January. If the value starts from 5-7, it should merge from February and similiarly, if the End week number is 53, it should merge till December and if the End week number is 44, it should merge till October.

So if the start week is 1 and End week is 44, the merging should start from Jan to October and should be one cell as the output with the value to be shown in the middle.​

 

[Legacy 143009]

OK, send a sample file with 4 or 5 rows.

 

[puppy26]

Yeah exactly. As mentioned earlier, in the above case, the value of start week is 1 and end week is 53, the merging should be from January to December and output should be one cell with showing value in the centre of the merged cell..

Just to give one more example.. If the start value is 5 and end week is 44, the merging should be from February to October.. Hope I'm clear now

 

[puppy26]

[TABLE="width: 683"]
<COLGROUP><COL style="WIDTH: 54pt; mso-width-source: userset; mso-width-alt: 2633" width=72><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 48pt" span=12 width=64><TBODY>[TR]
[TD="class: xl63, width: 72, bgcolor: transparent"]Starting Week[/TD]
[TD="class: xl63, width: 71, bgcolor: transparent"]Ending week[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Jan[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Feb[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Mar[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Apr[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]May[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Jun[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]July[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Aug[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Sept[/TD]
[TD="class: xl64, width: 64, bgcolor: transparent"]Oct[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Nov[/TD]
[TD="class: xl65, width: 64, bgcolor: transparent"]Dec[/TD]
[/TR]
[TR]
[TD="class: xl66, width: 72, bgcolor: transparent"]1[/TD]
[TD="class: xl66, width: 71, bgcolor: transparent"]53[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent, align: right"]2.00%[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, width: 72, bgcolor: transparent"]13[/TD]
[TD="class: xl66, width: 71, bgcolor: transparent"]14[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent, align: right"]6.00%[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, width: 72, bgcolor: transparent"]14[/TD]
[TD="class: xl66, width: 71, bgcolor: transparent"]17[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent, align: right"]10.00%[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, width: 72, bgcolor: transparent"]19[/TD]
[TD="class: xl66, width: 71, bgcolor: transparent"]21[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent, align: right"]6.00%[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, width: 72, bgcolor: transparent"]23[/TD]
[TD="class: xl66, width: 71, bgcolor: transparent"]25[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent, align: right"]-3.50%[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, width: 72, bgcolor: transparent"]28[/TD]
[TD="class: xl66, width: 71, bgcolor: transparent"]29[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent, align: right"]-2.00%[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, width: 72, bgcolor: transparent"]29[/TD]
[TD="class: xl66, width: 71, bgcolor: transparent"]40[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent, align: right"]7.00%[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, width: 72, bgcolor: transparent"]32[/TD]
[TD="class: xl66, width: 71, bgcolor: transparent"]34[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent, align: right"]-3.00%[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[/TR]
[TR]
[TD="class: xl66, width: 72, bgcolor: transparent"]36[/TD]
[TD="class: xl66, width: 71, bgcolor: transparent"]39[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl67, width: 64, bgcolor: transparent, align: right"]-3.00%[/TD]
[TD="class: xl67, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[TD="class: xl68, width: 64, bgcolor: transparent"] [/TD]
[/TR]
</TBODY>[/TABLE]

 

[puppy26]

In the above example, if the start week is 1 and end week is 53, the columns should be merged from Jan to Dec as one cell and 2% should be at the centre.

if the start week is 29 and end week is 40, the columns should be merged from July to October as one cell and 7% should be at the centre of the merged cell.

 

[Legacy 143009]

Sorry for a lot of questions. I am just trying to make it clear. What do you mean by merge? Summing percentages or display like "2.0%, 7.0%" in one cell?

EDIT: Ahaa! Only starting week value should be left in the center of merged cells!!! Ok give me a minute.