Hi Folks
I am in the process of writing an Excel Capacity Management Tool and am looking for help in combining rows where the Resource Name is the same as the previous row.
For example in the sample attached is row 8 has the same Resource Name as row 7 then I want to merge the values from Columns F to NL into row 7 and do the same for each row on the worksheet.
Note that columns F to NL are calculated based on the dates in columns "C". I intend to remove all formulas from columns F:NL before I run the routine to consolidate the rows.


I am struggling with the code for this so any help/advice would be appreciated.
Thanks in anticipation.
Tony

Attached Files

Sample Capacity Management Tool.xlsm (48.6 KB, 11 views)