2002 excel microsoft training - Data cosolidating

Good morning Asger,

Thanks for the question

Consolidating data is where you group all the numbers together and you can get a total (or average...) at the end. You have to use Data, consolidate, and make sure you pitch your cursor high up in the page the data is going to as the result appears below the cursor. Highlight the labels as well as the data and this works best when all the data is at the same place in each sheet.

Hope this helps

Tracy