searching multiple worksheets
 

I have set up a spreadsheet for a local squash league.

There are 12 worksheets, 1 for each month of the year, named
accordingly.
In Column A is the players first name, Column B their surname and in
Colum K their score for the month. (In between is game scores)

What I am trying to do is set up a running total for all competitors so
that at the end of the year I will have everyones monthly score and
total score over the year.

I have listed the player names (first and surname) in column A of
another worksheet, totalscores!, which has columns for each month.

I was wondering what formulae to use to search through the worksheets
to find the player in the monthly worksheet and return their score at
the end of the month.

Any help appreciated in advance.

stm


--
sonic-the-mouse

searching multiple worksheets
 

Hi,

You may need to create a helper column in each on the monthly spreadsheets
with one cell that contains both the first name and surname. Then in your
summary sheet you could do a vlookup and get the monthly score for each
player for each month.

Hope this helps.

Sean

"sonic-the-mouse" wrote
in message ...

I have set up a spreadsheet for a local squash league.

There are 12 worksheets, 1 for each month of the year, named
accordingly.
In Column A is the players first name, Column B their surname and in
Colum K their score for the month. (In between is game scores)

What I am trying to do is set up a running total for all competitors so
that at the end of the year I will have everyones monthly score and
total score over the year.

I have listed the player names (first and surname) in column A of
another worksheet, totalscores!, which has columns for each month.

I was wondering what formulae to use to search through the worksheets
to find the player in the monthly worksheet and return their score at
the end of the month.

Any help appreciated in advance.

stm


--
sonic-the-mouse

searching multiple worksheets
 

Hi Sonic,

Working on the basis that all your work sheets are in one workbook and
that each page has the data on it laid out in the same cells and that
the monthly total appears in the same cell on each work sheet, you can
SUM through the sheets.

In the summary sheet destination cell insert =SUM(

then select the JAN sheet tab, hold shift and select december sheet tab
- this will select all the sheets, select the cell that has the month's
total.

Close off the brackets and hit enter.

This will sum all the cels from the 12 sheets.

HTH

Ed


--
EdMac
------------------------------------------------------------------------
EdMac's Profile: http://www.excelforum.com/member.php...o&userid=30736
View this thread: http://www.excelforum.com/showthread...hreadid=528308

searching multiple worksheets
 

Sean

Sorry for delay in reply but your suggestion worked in with a contacts
list I had. Many thanks for your assistance.
stm
Sean Wrote:
Hi,

You may need to create a helper column in each on the monthly
spreadsheets
with one cell that contains both the first name and surname. Then in
your
summary sheet you could do a vlookup and get the monthly score for
each
player for each month.

Hope this helps.

Sean

"sonic-the-mouse"
wrote
in message ...

I have set up a spreadsheet for a local squash league.

There are 12 worksheets, 1 for each month of the year, named
accordingly.
In Column A is the players first name, Column B their surname and in
Colum K their score for the month. (In between is game scores)

What I am trying to do is set up a running total for all competitors
so
that at the end of the year I will have everyones monthly score and
total score over the year.

I have listed the player names (first and surname) in column A of
another worksheet, totalscores!, which has columns for each month.

I was wondering what formulae to use to search through the worksheets
to find the player in the monthly worksheet and return their score at
the end of the month.

Any help appreciated in advance.

stm


--
sonic-the-mouse


--
sonic-the-mouse