Then in the popping dialog, select the column which you will merge other columns based on then click Primary Key, and click another column and click Calculate then select Sum. Select the data you want to use and click Kutools > Merge & Split > Advanced Combine Rows. If you are not familiar with VBA code, you can use the Advanced Combine Rows feature of the third part add-in tool – Kutools for Excel to easily and quickly merge the duplicates rows then sum the values in another column.Īfter free installing Kutools for Excel, please do as below:ġ. Merge rows based on one column then sum values with Advanced Combine Rows Note: This VBA code just can correctly work when merging based on the first column and sum values in the second column. Now the data has been merged by first column and sum the values in second column. After selecting a working range, click OK. Press F5 or click Run button to run the VBA, and a dialog pops out for selecting a data range to work. Item(Rng.Value).Value + Rng.Offset(, 1)Ģ. With CreateObject('scripting.dictionary') Set InputRng = (InputRng.Columns(1).Address) Set InputRng = Application.InputBox('Range :', xTitleId, InputRng.Address, Type:=8) VBA: Merge rows based on one column value Sub MG30Nov12() Press F11 + Alt keys to enable Microsoft Visual Basic for Applications window, then click Insert > Module and copy and paste below VBA code to the new Module window. Here, Office Tab supports similar processing, which allow you to browse multiple Excel workbooks or Word documents in one Excel window or Word window, and easily switch between them by clicking their tabs. You may be familiar to view multiple webpages in Firefox/Chrome/IE, and switch between them by clicking corresponding tabs easily. Tabbed browsing & editing multiple Excel workbooks/Word documents as Firefox, Chrome, Internet Explore 10! There is a VBA code can help you to merge the duplicate rows then sum another column values. Merge rows based on one column then do different operations on other columns with Merge rows based on one column then sum values with Advanced Combine Merge rows based on one column then sum values with VBA

How to merge and center in excel 2011