Hi...struggling to get going on this task:
I have a series of headings in the range B5:B31 with values in D5:D31. What has to happen is the entries in B5:B31 need to be grouped under the headings listed in the attached sheet, the individual totals need to be grouped under the new headings and the new heading and totals then pasted to a new sheet with the headings starting in B9 and the corresponding total in cell G9.
The new headings should therefore occupy the range B9:B21.
Any ideas on the simplest way to achieve this task?
MZP