Need help to sort data automatically in first step, in 2nd merge rows if data in column C, D, E matched and sum their values of F, G, H & K columns.
Need formula or VBA code
for detail/further clarification file is attached.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
Merge rows and sum values VBA or Formula
0
Answers
0
To use the solution offered in the attached workbook please read the comments in the code which you will find in the module TeachExcel. You can change the starting row by assigning another value to the enumeration NwsFirstDataRow and you can change all columns to match changes in your workbook. Note that the code doesn't require columns to be consecutive although they, in fact are.
In the attached workbook the sheet Original Data is a copy of the top table from your Sheet1. The worksheet Solution is a copy of the Original Data. Running the procedure SortAndMerge will modify the data in Solution. To repeat the test copy Original Data back to Solutions. To expand testing, modify the sheet Original Data before creating a copy of it in Solutions.