Merge cells with same content

Originally Posted by MarvinP

Hi rainbowforest,

Excel works really well if your data is in a table with no blank rows or columns. See:
http://www.excel-2010.com/tables-in-excel-2010/ or
http://blogs.office.com/b/microsoft-...xcel-2010.aspx

It seems by your question, you want to remove or merge the similar data or group your data so it looks like:
You might be able to accomplish what you want by grouping your data instead of merging. See:
http://www.lynda.com/Excel-2010-tuto...s/68238-4.html

In general it is a bad idea to merge your cells into a single cell.

Hello MarvinP,

I'll take a look into the links. I know it's a bad idea to merge these cells and honestly I wouldn't do it because I don't think the report looks any better. On the contrary. But that's how the management wants it, so I just have to go by their wishes. Since this merging is the last step in the process of creating this report, I figured I might as well merge the cells since I won't need to reference it anymore. I copied/pasted all the values so hopefully merged cells won't affect this daily report.

All that is good, but I need to do this via VBA code. I know how to use Excel to merge cells and group, but that's now what I need in this case. I need VBA to do this automatically for me, since the rest of the report is done in VBA, not manually.

Previously, this report was done manually which meant spending 1.5 hrs every day which is ridiculous. Now, I'm trying to make this entirely in VBA so it can be done in couple of seconds. I finished 95% of the report in code, and now this merging part is suppose to be one of the last steps.

hi, rainbowforest, can you post sample workbook showing original data and result you need to obtain?

Originally Posted by watersev

hi, rainbowforest, can you post sample workbook showing original data and result you need to obtain?

Please look at the attachment. To the left is the current look of the report (first three columns), and to the right is the desired appearance of the report.

Thanks!

Thank you watersev. That worked!

Originally Posted by watersev

hi, rainbowforest, please check attachment, run code "test"

I forgot that I have the header row in original report and now it merges with the first record when I run this piece of code. What do I need to add in order for this code to skip the first header row? Thanks.

Originally Posted by watersev

hi, provided title is in row 1, change this:

Please Login or Register  to view this content.

to this:

Please Login or Register  to view this content.

or check attachment

Excellent! I figured data_rng needed to be fixed but I couldn't figure out the way to do it. It works now. Thanks!