Pull data from identical sheets onto master sheet

**veritas1** · 03-04-2011, 04:06 PM

Hello all

Fairly new to excel, learning still.

First off, what I am doing is creating a football stat book.
So I have 10 sheets, 1 for each game that is used to record the stats from each individual game. Then a seasons total sheet at the front (master sheet) that keeps a running total.

Now I have got this to work using a formula such as this in the master sheet cells:

=SUM(SUMPRODUCT(('GAME 1'!$B$5:$B$80='PLAYER SEASON STATS'!A5)*('GAME 1'!$D$5:$D$80="YES")),SUMPRODUCT(('GAME 2'!$B$5:$B$80='PLAYER SEASON STATS'!A5)*('GAME 2'!$D$5:$D$80="YES")).....

this repeats over 10 times for the 10 pages. I just copy and paste the script and then manually change the sheet name to the next one.....SO my question is, is there a quicker/better way??? because this is quite time consuming....

Any help greatly appreciated, thanks for reading.

**DonkeyOte** · 03-07-2011, 11:33 AM

@veritas1, welcome to the board

Please note we have several question forums and though the layout of the forum can be confusing at times we do ask you try to post in the forum most appropriate to your question.

In this instance I have moved your thread from MS Access Forum to Excel General.

Please also confirm you are running Mac 2008 version of Excel as this directly impacts options open to you (specifically no VBA support)