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:
www.pk-anexcel...
Download our free Excel utility Tool and improve your productivity:
www.pk-anexcel...
See our Excel Products:
www.pk-anexcel...
Visit to learn more:
Chart and Visualizations: www.pk-anexcel...
VBA Course: www.pk-anexcel...
Download useful Templates: www.pk-anexcel...
Dashboards: www.pk-anexcel...
Watch the best info-graphics and dynamic charts from below link:
• Dynamic Graphs
Learn and free download best excel Dashboard template:
• Excel Dashboards
Learn Step by Step VBA:
• VBA Tutorial
Website:
www.PK-AnExcel...
Facebook:
/ pkanexcelexpert
Telegram:
t.me/joinchat/...
Twitter:
/ priyendra_kumar
Pinterest:
/ pkanexcelexpert
Send me your queries on telegram:
@PKanExcelExpert
************ Suggested Books ********
VBA: amzn.to/2TMMikX
Excel Dashboard: amzn.to/2WZi2Fj
Power Query: amzn.to/2Ibd7xR
Power Pivot and Power BI: amzn.to/2DCg8BB
Exam Ref 70-778 (Power BI): amzn.to/2GnWYTN
************ My Stuff ***************
Mic : amzn.to/2TLnF88
Video Editor: screencast-o-m...

[@anandkishore9]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@elliotthopkins8661]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@gl_coimbra]

Thank you so much! Ended up downloading your AddIn

[@PKAnExcelExpert]

Thanks 🙏

[@jebingeorge9698]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@misalee433]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@phimiuniu]

Super helpful. Thank you!

[@PKAnExcelExpert]

You're welcome!

[@Ruqqayahzahra.123]

I was searching for this thanks 🎉🎉🎉

[@PKAnExcelExpert]

Most welcome🙏

[@atulbharti7880]

Sir,You are the only youtuber who give and teach Vba code properly and also tell us how it works step by step.Other just say link in description box you can get from there.Hats off to u sir🫡🫡

[@PKAnExcelExpert]

Thanks

[@BryanSeigneur0]

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.

[@NgocNguyen-oc6ow]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@murtazaiqbal7267]

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..😊👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@thatzevy]

LIFE SAVER! THANK YOU!

[@PKAnExcelExpert]

You're welcome!

[@queuedreads]

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

[@raissaveneziaborba8230]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@vinachatte]

Thanks! very helpful!

[@PKAnExcelExpert]

Glad it helped!

[@galaxialove369]

You are the best!

[@PKAnExcelExpert]

Thanks🙏

[@pandharinathjoshi6565]

Sir i have seen this video sir
Actually exact need this one sir
Its very usefull sir

[@PKAnExcelExpert]

Thanks

[@sureshchand2393]

Thank you Sir, It was really helpful for me.

[@PKAnExcelExpert]

Glad to hear that

[@bbiggie97]

You're the best, thanks for the tutorial.

[@VillaOuk]

Thanks very much. Cool trick

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Misicuni20]

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

[@PKAnExcelExpert]

Thanks

[@qatar-hd4709]

Thank you so much , it works perfect 👍👍👍

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Agapeisthebest]

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

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@nizarhasanbisri8758]

Super helpfull!!! thank you

[@PKAnExcelExpert]

Most welcome🙏

[@jepnkd]

Great tips thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ExcelMadeEasy444]

Excellent !!! Great Job.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@ruchidahiya4260]

Thankyou...helped me a lot

[@PKAnExcelExpert]

Most welcome

[@m.mahesh2155]

Super explanation👍👍👍👍🎂🎂🎂🌹🌹🌹🌹

[@PKAnExcelExpert]

Thanks🙏

[@ishtiaqkhan1832]

very nice tutorial

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Saatt79]

Awesome one sir as usual 👏👏👏

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@matrva]

Good one!

[@PKAnExcelExpert]

Thanks🙏

[@vascomartins2654]

You're the goat!

[@tirumalareddynagarsachival1091]

THANK YOU FOR YOUR HELP

[@PKAnExcelExpert]

Welcome

[@joeheldelrosario461]

Very helpful. Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@MohAboAbdo]

Thank you very much for this great video and for this excellent explanation.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sevakbhargav]

Out standing

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@chalaava]

thanks!

[@PKAnExcelExpert]

Welcome!

[@SyedMuzammilMahasanShahi]

Beautiful work as usual. Thanks for the share.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@Leo-ec3rq]

Great thank you! still so useful

[@PKAnExcelExpert]

Thanks for your valuable feedback🙏

[@Deepak726verma]

Thanks a lots.

[@PKAnExcelExpert]

Most welcome!

[@KL6400]

Thank you sir🤩 Very useful tool!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sehlebasheer4709]

Can we do it with Power Query

[@gilberto00]

Amazing instructions. Thanks, man!

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@sasavienne]

Simply great. Thank you so much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@mrisnaini4631]

thank you for sharing knowledge is very helpful

[@marjmoniquecabical9341]

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.

[@tugrulbozbey9700]

Thank you, it works.

[@PKAnExcelExpert]

You're welcome!

[@9181shreyasbhatt]

Very helpful. Thank you very much.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TamilMoviesQuiz]

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.

[@VishalSharma-rn7mt]

great video thank you so much for this solution.

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@TheBaljeet123]

Can we use this for date column
And One more thing i want that i want to sum the value in another column....plz help

[@hafijul233]

Thank you. Excel file need to be .xlsm format to work

[@Anik2024-o5m]

Thanks a ton, subscribing your channel for this video.

[@PKAnExcelExpert]

Thanks for watching and subscribing. Welcome 🙏

[@scitcivil7623]

Sir I want to fill the data to the right and merge to the right how can I do t can you explain it sir

[@siddhuprince1]

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

[@rhondabrown5532]

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.

[@lucasrossi1175]

Excellent!

[@samnangsuonsokunth8719]

sir can we merge with out selection vba?

[@mdazheralikhan7685]

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

[@sandeepkumar-cx4or]

thank a lot of you for sharing this

[@PKAnExcelExpert]

Thanks for watching

[@Monir7034]

very good..

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@khaledsaleh8604]

Good work
Thank you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@kapilm6837]

This has helped me a lot but how to have sum of total for merge cells in next column against each merge cell

[@AbijithVP-m4i]

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

[@koushikkumarroychowdhury1034]

Can we sum it in the last column based on First column criterion?

[@snowyseptember1610]

Thanks a lot Sir, that's really helpful

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@admingb1123]

Nice sir, is it possible in google sheet? plz reply

[@ghazwankhalid]

Thank You bro.

[@PKAnExcelExpert]

You're welcome!

[@rickkeev4919]

Good vid; thanks for sharing. It would have been nice to include the reverse (unmerge)

[@dianari1457]

thanks so much!!

[@PKAnExcelExpert]

Thanks for watching

[@hussenshakoor]

thank you so much , i love you

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@taruntyagi12]

Realy helpful

[@patkartarun]

Thanks alot

[@nelsonalva]

My man!

[@raghavendranl]

Sir, it's helped lot to me. Thank you. Can I use same formula in Google spread sheets. Phase reply me.

[@khairulaznal8769]

but does it have to run every time I open excel because it seems like it needs to run again once I close it and open it again

[@ibm98852]

Thanks for useful video...
How can we add a blank row in each merged cell. Sometime we have only one cell, so need not merge it but need blank row in between two rows.
Thanks in advance

[@metasol7477]

Useful!! However, I come to a problem with this-it will only merge cell that are in order. How about a modified macro where you can merge cells not in order? For example: January, March, January, February, March data order. Thanks

[@sharathnb]

I think then, we have to first sort the column in ascending or descending order and then apply VB

[@JaimaocantaJaimao]

Thank you PK this is so valuable! Subscribed immediately. What if I wanted to also merge blank cells?

[@rituparnachatterjee713]

Hello, is there is any formula which I can use instead of VBA for marging the data. Plz inform

[@majidsiddique8227]

Excellent

[@trojan211281]

Excellent... thanks a lot. It is extremely useful and I was searching for something exactly like this. Just a question, will it do sorting the whole rows as well ? Like in your example if another pk was at the last of the column, would it bring it up and then do the merge ?

[@NataliaAcevedoG]

I have the same question

[@danishhaider101]

thanks sir

[@PKAnExcelExpert]

Most welcome

[@byahmohammed6849]

thaank you sir , that's so helpful

[@PKAnExcelExpert]

Thanks for your appreciation. Request you to please share this with your friends and colleagues.

[@kirbyallen8396]

Is there a way for me to have borders around the merged lines after it is seperated? For example, there would be a new border line between January, Feb, etc. from this code that would show up after the merge?

[@PKAnExcelExpert]

Yes, we can create border. need to a piece of code accordingly

[@Nevir202]

So, tried this and a few other scripts too, every single thing just throws errors about ';' expected.
Anyone know what's up with that?

[@AN-yj9qv]

How do a create the macro it says error

[@archanaaa2514]

Sir, I am beginner to vba.. As a beginner how much we need to learn in vba code part? Wat we must knw

[@abdulrehmanaltaf9504]

thanks dear... wow...

[@PKAnExcelExpert]

Thanks for your valuable feedback

[@pascualmorante2687]

Help, It says compile error "Label not define" then the GoTo Mergecells are highlightened

[@Bangladesh689]

How to do the same thing on MS word?

[@aniruddhamukherjee6146]

what version of excel should we have to use developer option and all

[@PKAnExcelExpert]

Developer Tab is available in Excel 2007 and above versions. You need enable this. Please watch below video-
ua-cam.com/video/q8AZ2TGbY7M/v-deo.html

[@GaneshSutar-mf7bs]

How to Unmerge once data changed from similar range

[@airjentzen7406]

I am currently using this macro and transposing it when I'm finished. How would you change the Macro to merge same cells within rows instead of columns. Thanks!

[@johnny51981]

AIRJENTZEN I just played around with this, as this video got me on the perfectly correct path. To merge horizontally (as opposed to the displayed vertically), simply invert all 4 of the (1, 0) to read (0, 1).

[@muthurajmmuthu1839]

Could you please give me code for unmering cells and repeat the values of merged cells

[@jagannathan4750]

Why it's not working for rows merging?

[@mohamedseda3735]

How to avoid null fill for a cell after merging multiple cells
As we I make a filter it looks at the merged cell as empty, however i don't want that

[@AngelStickman]

I don't know what changed since you made this but this loop crashes on me. Either it doesn't stop and is merging empty cells or it merges everything correctly then crashes at the if statement when it runs out of values. Its not very robust.

[@alexandergonzalojimenezcas3984]

ME ENCANTO PODRIA AYUDARME QUIERO COPIAR VALORES DE ACUERDO AL CHECK DE REVISION Y QUE SOLO ME COPIE ESOS VALORES QUE ESTAN CON EL CHECK A OTRA HOJA PLEASE

[@shaikhaziz9703]

sir, i want to merge column based on first value
e.g. in columnA (A2) i have numric value something 50 and after 40 blank rows i have another value like 60, and so on:
please suggest any code