merging data from several spreadsheets into one

  • Thread starter Thread starter steven.rethy
  • Start date Start date
S

steven.rethy

Hi I am doing stats for my son's hockey team and I have
made a Microsoft Excel 97 spreadsheet (game sheet) for
each game they will play with all players listed and
several types of stats. I will do a spreadsheet for each
game but I want to know how to merge all the data from
each sheet(add them up) into one "Running totals sheet"
Please help
 
Hi Steven

If you only want to sum you can do this

Add two dummy sheets(empty sheets)with the name start as the first sheet
and one with the name end as the last sheet of your workbook.
this are empty sheets!!!

All worksheets between these sheets will be sum
with this formula

=SUM(start:end!A1)
 
Hi,

Try the following in the consolidsted sheet (hope the structure of all the
Games is the same i.e. the rows and columns for the different stats is the
same for all the worksheets.

In the consolidated sheet, go to the cell (criteria) for which you want the
data added
Go to Data>Consolidate and select the function
In the reference box, give the cell reference of criteria in the first
worksheet and click Add
Follow the same for all the worksheets

Check the "Create Links to source data" box

Click on OK

Hope this helps

Regards,

Ashish Mathur
 
Back
Top