No video :(

VBA: Quickly Merge Cells with Same Values in Excel

Подписаться 273 тыс.

Просмотров 166 тыс.

50% 1

#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...

Опубликовано:

19 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 187

@anandkishore9 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@BryanSeigneur0 4 года назад

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.

@murtazaiqbal7267 4 года назад

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 4 года назад

Thanks for your valuable feedback

@jebingeorge9698 3 года назад

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

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@misalee433 3 года назад

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

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@elliotthopkins8661 3 года назад

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

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@pandharinathjoshi6565 4 месяца назад

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

@PKAnExcelExpert 4 месяца назад

Thanks

@m.mahesh2155 8 месяцев назад

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

@PKAnExcelExpert 8 месяцев назад

Thanks🙏

@sevakbhargav 2 года назад

Out standing

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback

@patq1574 3 года назад

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

@thatzevy 3 года назад

LIFE SAVER! THANK YOU!

@PKAnExcelExpert 3 года назад

You're welcome!

@NgocNguyen-oc6ow 3 года назад

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

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@Ruqqayahzahra.123 Год назад

I was searching for this thanks 🎉🎉🎉

@PKAnExcelExpert Год назад

Most welcome🙏

@phimiuniu 10 месяцев назад

Super helpful. Thank you!

@PKAnExcelExpert 10 месяцев назад

You're welcome!

@matrva Год назад

Good one!

@PKAnExcelExpert Год назад

Thanks🙏

@Deepak726verma 2 года назад

Thanks a lots.

@PKAnExcelExpert 2 года назад

Most welcome!

@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.

@Misicuni20 2 года назад

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

@PKAnExcelExpert 2 года назад

Thanks

@sureshchand2393 2 года назад

Thank you Sir, It was really helpful for me.

@PKAnExcelExpert 2 года назад

Glad to hear that

@vascomartins2654 Год назад

You're the goat!

@vinachatte 8 месяцев назад

Thanks! very helpful!

@PKAnExcelExpert 8 месяцев назад

Glad it helped!

@bbiggie97 3 года назад

You're the best, thanks for the tutorial.

@raissaveneziaborba8230 3 года назад

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

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@Agapeisthebest 4 года назад

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

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@qatar-hd4709 3 года назад

Thank you so much , it works perfect 👍👍👍

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@MohAboAbdo 5 лет назад

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

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@loknathan7 3 года назад

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.

@nohelirangel2165 Год назад

You are the best!

@PKAnExcelExpert Год назад

Thanks🙏

@VillaOuk 3 года назад

Thanks very much. Cool trick

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@chalaava 7 месяцев назад

thanks!

@PKAnExcelExpert 7 месяцев назад

Welcome!

@jepnkd 3 года назад

Great tips thank you

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@joeheldelrosario461 3 года назад

Very helpful. Thank you

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@ruchidahiya4260 2 года назад

Thankyou...helped me a lot

@PKAnExcelExpert 2 года назад

Most welcome

@ExcelMadeEasy444 5 лет назад

Excellent !!! Great Job.

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@nizarhasanbisri8758 10 месяцев назад

Super helpfull!!! thank you

@PKAnExcelExpert 10 месяцев назад

Most welcome🙏

@tirumalareddynagarsachival1091 3 года назад

THANK YOU FOR YOUR HELP

@PKAnExcelExpert 3 года назад

Welcome

@ishtiaqkhan1832 3 года назад

very nice tutorial

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@mrisnaini4631 3 года назад

thank you for sharing knowledge is very helpful

@sasavienne 5 лет назад

Simply great. Thank you so much.

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@gilberto00 4 года назад

Amazing instructions. Thanks, man!

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@SyedMuzammilMahasanShahi 5 лет назад

Beautiful work as usual. Thanks for the share.

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@Leo-ec3rq 2 года назад

Great thank you! still so useful

@PKAnExcelExpert 2 года назад

Thanks for your valuable feedback🙏

@metasol7477 5 лет назад

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 3 года назад

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

@rhondabrown5532 2 года назад

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.

@Saatt79 5 лет назад

Awesome one sir as usual 👏👏👏

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@VishalSharma-rn7mt 4 года назад

great video thank you so much for this solution.

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@KL6400 5 лет назад

Thank you sir🤩 Very useful tool!

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@mdazheralikhan7685 3 года назад

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

@kapilm6837 3 года назад

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

@Mohamed-Haliba 4 года назад

Great code . Please help me to run this code with VBSript because it gives me error "mismatch " for IF sentence " If rng.Value = rng.Offset(1, 0).Value And rng.Value "" Then"...Please try to code it again with another syntax ..thanks very much

@rickkeev4919 5 лет назад

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

@tugrulbozbey9700 4 года назад

Thank you, it works.

@PKAnExcelExpert 4 года назад

You're welcome!

@sandeepkumar-cx4or 5 лет назад

thank a lot of you for sharing this

@PKAnExcelExpert 5 лет назад

Thanks for watching

@siddhuprince1 2 года назад

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

@hafijul233 3 года назад

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

@sehlebasheer4709 4 года назад

Can we do it with Power Query

@gabanpangestu 3 года назад

Thankyou sir

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

@ibm98852 5 лет назад

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

@Anik2024-o5m 3 года назад

Thanks a ton, subscribing your channel for this video.

@PKAnExcelExpert 3 года назад

Thanks for watching and subscribing. Welcome 🙏

@ghazwankhalid 4 года назад

Thank You bro.

@PKAnExcelExpert 4 года назад

You're welcome!

@khaledsaleh8604 5 лет назад

Good work Thank you

@PKAnExcelExpert 5 лет назад

Thanks for your valuable feedback

@pascualmorante2687 2 года назад

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

@lucasrossi1175 3 года назад

Excellent!

@jamphelj117 2 года назад

doesn't work in windows 10 I guess, it says 'object doesn't support this property or method'. I used the same code yet failed.

@Monir7034 3 года назад

very good..

@PKAnExcelExpert 3 года назад

Thanks for your valuable feedback

@AngelStickman 4 года назад

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.

@mohamedseda3735 2 года назад

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

@snowyseptember1610 4 года назад

Thanks a lot Sir, that's really helpful

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@JaimaocantaJaimao 3 года назад

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

@trojan211281 3 года назад

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 3 года назад

I have the same question

@hussenshakoor 4 года назад

thank you so much , i love you

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@khairulaznal8769 3 года назад

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

@TheBaljeet123 2 года назад

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

@GaneshSutar-mf7bs Год назад

How to Unmerge once data changed from similar range

@dianari1457 4 года назад

thanks so much!!

@PKAnExcelExpert 4 года назад

Thanks for watching

@raghavendranl 3 года назад

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

@jagannathan4750 10 месяцев назад

Why it's not working for rows merging?

@nelsonalva 3 года назад

My man!

@danishhaider101 4 года назад

thanks sir

@PKAnExcelExpert 4 года назад

Most welcome

@byahmohammed6849 5 лет назад

thaank you sir , that's so helpful

@PKAnExcelExpert 5 лет назад

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

@taruntyagi12 4 года назад

Realy helpful

@patkartarun 3 года назад

Thanks alot

@alexandergonzalojimenezcas3984 4 года назад

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

@fostani4418 Год назад

i did download the tool, but didn't work! every time i click on it nothing happend

@samnangsuonsokunth8719 10 месяцев назад

sir can we merge with out selection vba?

@pandharinathjoshi6565 4 месяца назад

Sir, need help sir Sir I have used this but names are same also name related data numbers or values also same How can merge for values also same sir Depending Names range related data only merge how can we do sir I am facing too big data sir pls

@koushikkumarroychowdhury1034 Год назад

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

@abdulrehmanaltaf9504 4 года назад

thanks dear... wow...

@PKAnExcelExpert 4 года назад

Thanks for your valuable feedback

@admingb1123 2 года назад

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

@AN-yj9qv 2 года назад

How do a create the macro it says error

@Bangladesh689 3 года назад

How to do the same thing on MS word?

@majidsiddique8227 5 лет назад

Excellent

@Bromasrur_07 4 года назад

Suppose I have A data Table: In Column "A" ( A3 To A7") Contain Same Style NO, Column "B" ( B3 to B7 ) Contain 5 Different PO # ( Under the Same Style) & Column "C" (c3 to c7) Contain 5 different Qty for EAch PO (Under The Same Style ). I want "D3 to D7" Will Be Marged & Value Of C3 to c7 Will Be Summarized in this Marged Cell ,PLease Help

@muthurajmmuthu1839 3 года назад

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

@rajuthangellapally4632 4 года назад

Sir I am getting Run-time error '1004' Application-defined or object-defined error please help me

@gideonengelbrecht8723 4 года назад

Me too

@gideonengelbrecht8723 4 года назад

Seems it only works on ranges and not tables

@rituparnachatterjee713 2 года назад

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

@shaikhaziz9703 3 года назад

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

@amoljunghare3610 4 года назад

Thank You Sir....Pls tell me how to calulate the sum of merged data on right side.e.g In 2001 the sales are 348,311,383 so by using ur method 2001 will be merged and i want the total sum of 348+311+383 on right hand side.How will i do this??