searching multiple worksheets

[sonic-the-mouse]

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

There are 12 worksheets, 1 for each month of the year, name
accordingly.
In Column A is the players first name, Column B their surname and i
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 s
that at the end of the year I will have everyones monthly score an
total score over the year.

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

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

Any help appreciated in advance.

st

 

[Sean]

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

 

[EdMac]

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

 

[sonic-the-mouse]

Sean

Sorry for delay in reply but your suggestion worked in with a contact
list I had. Many thanks for your assistance.