Depends on what you exactly mean with consolidating. You could copy/
paste the data and use a pivot to get your report. Otherwise look up
the Data/Consolidate function in Help. It might be the answer to your
problem

DQ