Consolidation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Sub-total using Advanced Filter? 4
Summing using column Heading 5
Consolidating Values 5
Displaying data Horizontally 3
Copy & Paste - Unsafe? 4
Cell data based on autoshape color 2
Macro to Sort 4
Using Consolidate Methode with a relative Range 0

Back
Top