I have a a load of data on a single sheet. I need to consolidate to the
unique values present in column H, whilst maintaining the header rows and
format of the sheet. Does anyone have some code to do this please?

Sort based on column H, then use Data / Subtotals.... and set the subtotals to sum based on changes
in column H, and sum whichever columns you need to. Then hide the data using the - signs that
appear to the left, select all the cells, use Edit / Go to... / special / visible cells / OK, copy,
and then choose a place to paste and paste values.

HTH,
Bernie
MS Excel MVP


"General" wrote in message
...
I have a a load of data on a single sheet. I need to consolidate to the
unique values present in column H, whilst maintaining the header rows and
format of the sheet. Does anyone have some code to do this please?