Assemble table in new w/s from rows selected in other w/s

I've added in a special new function that doesn't exist in Excel, it's called STRING CONCATENATION. This allows you to do a SUMIF() type analysis of a range of values, but instead of adding when values match, it gathers text strings together and lists them together in a cell.

The UDF I installed is called CONCATIF().
http://www.excelforum.com/excel-prog...in-cell.html#2 'explanation


I also added a new CUSTOM2 sheet that you can use to organize the first CUSTOM sheet into the order you want. Just list the items in column A in the order you wish to see them. The CONCATIF() formulas in the other columns will gather the matching items from CUSTOM sheet and display them altogether.

I also added a worksheet_activate event to that Custom2 sheet so the rows/columns autofit to display as good as possible each time you look at that sheet.