I have a excel files with data in 11 columns. Each row describes a particular service offered to a client (columns contain client info, product description, delivery date, cost). For a billing summary, we need to aggregate by service category and client. The catch is that the client has provided a sample excel layout which we must copy exactly, so we can't just do a pivot table or move everything over to access or filemaker. What I want is to have a macro in excel that will simply create a new worksheet in the same workbook where I have my data laid out in a table--just do a hotkey and voila. The new worksheet will have the billing summary. I am attaching an [url removed, login to view] format has to be exactly as in the attached, colors and merged cells and everything.