VBA: Quickly Merge Cells with Same Values in Excel

#MergeSameCells #VBAtutorial #ExcelTips
Hello Friends,
In this video you will learn how to merge cells with same values in Excel using VBA. This is a time saving trick. You can copy this code to your personal macro so that it can be available for each workbook.

Please download this excel file from below given link:

Download our free Excel utility Tool and improve your productivity:

See our Excel Products:

Visit to learn more:

Watch the best info-graphics and dynamic charts from below link:

Learn and free download best excel Dashboard template:

Learn Step by Step VBA:

Website:

Facebook:

Telegram:

Twitter:

Pinterest:

Send me your queries on telegram:
@PKanExcelExpert

************* Suggested Books *********

************* My Stuff ****************

[anandkishore]

Thank you Sir. The code was explained in very simple and easy to understand way. Please keep it up.

[elliotthopkins]

Amazing, exactly what I was looking for. Thank you!

[BryanSeigneur]

Thank God the main part of this program is only a few lines long and also for you starting with the main part. Also thank you for demonstrating the script at the beginning. This is a great thing for spreadsheets to be able to do to make data clearer. It should be a standard function.

I've often wanted this for many things. I am using it now for query results, kind of a quick and dirty grouping report for my own use. It makes the data VERY VERY much each easier to see and find what I'm looking for.

[rhondabrown]

Thank you, your tutorial is very helpful. How would you change the macro if you want the merge to be across columns? My range would be from Col. J to Col. BI and I would like to combine (consecutive) cells wit the same input data.

[murtazaiqbal]

Wow... Thank you so much... It helps a lot... I want to organize data which is in 1000s and was searching for efficient way to group and order by specific range and here it is... Simply outstanding and easy..😊👍

[misalee]

I was struggling on this issue today, this helped me very much. thanks :)

[jebingeorge]

Thank You sir. You saved me a lot of time. especially by providing the code.

[mdazheralikhan]

Thank you for explaining the code, it was really helpful. One small question incase if I need to add totals here what should be done

[siddhuprince]

Thank You very much, code neat and clear, i have query, suppose if we have one row of column with value, next 3 rows blank, any after the blank row one more rows starts with another different value, and this continues for every 3 blank rows a new row with details is present in the sheet, then how to merge with VBA

[raissaveneziaborba]

Thank you so much!!! Keep the good job ;)

[AbijithVP-mi]

Hy, i have a question. If the values in the first column is in disorder(in your excel if January is comes again after February) can we use this program??

[marjmoniquecabical]

under the code "If rng.Value = rng.Offset(1, 0).Value And rng.Value <> "" Then", excel shows error 1004, that is, rng.value is neither application-defined or object defined; rng.Value = empty. Please help.

[NgocNguyen-ocow]

it's very useful, thanks a lot. You got my subscription.

[Agapeisthebest]

Your channel is Thanks for sharing well explained, quality content.

[pandharinathjoshi]

Sir i have seen this video sir
Actually exact need this one sir

Its very usefull sir

[loknathan]

Sir, that's really good. My requirement is different, I want to merge rows (different data) in one cell (looks like rows only) without losing any data.

[Misicuni]

this is amazing!!! Thank you so much for your help and offer to download. It works perfectly

[bbiggie]

You're the best, thanks for the tutorial.

[sureshchand]

Thank you Sir, It was really helpful for me.

[patq]

Thank you so much for this!! You just saved me from 800 rows of data!! Cheers!