How to integrate three separate sheets of data collected in three separate time frames

Dear Linda

Thank you for attending Excel Introduction course. I hope you enjoyed the training.

I am not sure if I understand your question very clearly. In Intermediate course we cover a topic called Consolidate which should hopefully get you the result that you are looking for. If it is doesn’t then I would request you to reply to this post and give more specific example which may assist me to provide you with a better response.

Consolidating Data is used for summarizing data that may be stored in various worksheets within the same workbook or in separate workbooks.

To consolidate data:

Step 1: Select the Sheet where the data will be consolidated and also click on the relevant cell where the result of the consolidation will take begin.

Step 2: Choose Data > Consolidate… from the Menu bar.

Step 3: In the Consolidate Dialog box from the Function dropdown list Sum is chosen by default as this is the most common type of consolidation users perform. You can also perform Average, Min, Max, etc…

NB: Consolidation feature works best when the data on all the worksheets has the similar layout. However it is not necessary to have it laid out in this manner.

Step 4: Click on the reference box and select the relevant sheet and the cells that you want to include as first part of your consolidation range.

NB: Please select the rows and columns headings while performing the above step if the Master worksheet doesn’t contain any data.

Step 5: Click the Add button on the Consolidate dialog box. Repeat steps until you select all the data that you wish to include for consolidation.

Under the Use labels in section check if you want the Row and Column headings to be included in the Master worksheet.

If the Consolidated data needs to be updated regularly from other sheets you can put a check on the create links to the source data. If you are consolidating one off report then you may decide not to create the link.

Step 6: Press OK Button.

I hope this Clarifies your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to answer that!!

Many thanks

Rajeev Rawat
MOS Master Instructor 2000 and 2003