If cell values equal, then merge cells

**TonyforVBA** · 08-26-2011, 10:02 AM

Hey folks,

I need a macro or formula to merge cells with identical content. Any ideas on the best way to do this?

Cheers!

**mrice** · 08-26-2011, 03:00 PM

Try this

Please Login or Register  to view this content.

I've assumed that you want to merge both horizontally and vertically.

**TonyforVBA** · 08-30-2011, 10:24 AM

Cheers for that MRICE,
I'm just about to get working on this now so I'll let you know how I get on.
thanks again.

**TonyforVBA** · 08-30-2011, 10:41 AM

This is almost exactly what Im looking for.

The only issue is that in some instances this code will need to merge mabe 5 or 6 cells (with identical content) on a verticle axis.

Is there a way of changing this code so that it will continue to merge identicle cells until a cell containing differant content or a null cell is reached?

Cheers again!

**mrice** · 08-30-2011, 02:27 PM

Can you provide an example as an attachment of a scenario that is currently not covered by the code and show what you would like it to look like?

**TonyforVBA** · 08-31-2011, 04:19 AM

Sure thing. I've attached an example before & after data set now.

Thanks again for your help on this.

**mrice** · 09-01-2011, 08:52 AM

This works on your sample data.

Please Login or Register  to view this content.

**suzq73** · 02-28-2013, 06:22 PM

Martin,

I have a similar situation, but I want to merge the names in column A. Can you please assist with how I would need to alter the above code to do this?

My spread sheet is on a very large scale also and there may be up to 100 names that need to be merged at times. Do I need to change any other parts of the code to accommodate for this?

thanks

Sue.

**arlu1201** · 03-01-2013, 01:19 AM

Sue,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.