I have 1 worksheet that needs to pull the scores from several other worksheets.

Problem is... the other worksheets change order depending on top score
(which I sort manually), so I can't put in an absolute reference to the other
worksheet cells, because it would give me the wrong number.

Barb, something like this should work, =Sheet2!A1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Barb" wrote in message
...
I have 1 worksheet that needs to pull the scores from several other
worksheets.

Problem is... the other worksheets change order depending on top score
(which I sort manually), so I can't put in an absolute reference to the
other
worksheet cells, because it would give me the wrong number.

It doesn't, because as soon as I sort the individual score worksheet, the
totals worksheet pulls the data from the !A1 cell, which now has another
contestants name.

What about naming the cells, and doing something with that???

"Paul B" wrote:

Barb, something like this should work, =Sheet2!A1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Barb" wrote in message
...
I have 1 worksheet that needs to pull the scores from several other
worksheets.

Problem is... the other worksheets change order depending on top score
(which I sort manually), so I can't put in an absolute reference to the
other
worksheet cells, because it would give me the wrong number.

Barb, when you said "sort manually" I thought you were sorting the worksheet
tabs, my bad, have a look at index and match here and see if this will work
for you http://www.contextures.com/xlFunctions03.html if not you may want
to post back with more information on how your workbook is set up and what
you want it to do.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Barb" wrote in message
...
It doesn't, because as soon as I sort the individual score worksheet, the
totals worksheet pulls the data from the !A1 cell, which now has another
contestants name.

What about naming the cells, and doing something with that???

"Paul B" wrote:

Barb, something like this should work, =Sheet2!A1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Barb" wrote in message
...
I have 1 worksheet that needs to pull the scores from several other
worksheets.

Problem is... the other worksheets change order depending on top score
(which I sort manually), so I can't put in an absolute reference to the
other
worksheet cells, because it would give me the wrong number.

I couldn't get to the webpage you suggested, so here's another version of my
problem.

Rodeo Scores
Cowboys ride in different events, therefore each tab is an event with name
and score.
Example:
Tab - Bull Riding (Event) (Event Dates)
Total 4/1 4/2 5/1 5/2 6/6 6/7
Cowboy 1 58 10 9 10 9 10 10
Cowboy 2 57 9 10 10 9 9 10

Tab - Bare Back (Event) (Event Dates)
Total 4/1 4/2 5/1 5/2 6/6
6/7 7/6 7/7
Cowboy 2 57 9 9 10 9 10 10
Cowboy 1 56 9 10 10 9 8 10

Tab - Totals
Bull Riding Bare Back
Cowboy 1 58 56
Cowboy 2 57 57

I'm trying to create a 'totals' tab with total score for each event.
However, when I manually sort the 'event' tab, ranking the highest score at
the top, this changes the cells that I've referenced my 'total' worksheet to.

Thanks for your time... it's really appreciated!


"Paul B" wrote:

Barb, when you said "sort manually" I thought you were sorting the worksheet
tabs, my bad, have a look at index and match here and see if this will work
for you http://www.contextures.com/xlFunctions03.html if not you may want
to post back with more information on how your workbook is set up and what
you want it to do.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Barb" wrote in message
...
It doesn't, because as soon as I sort the individual score worksheet, the
totals worksheet pulls the data from the !A1 cell, which now has another
contestants name.

What about naming the cells, and doing something with that???

"Paul B" wrote:

Barb, something like this should work, =Sheet2!A1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Barb" wrote in message
...
I have 1 worksheet that needs to pull the scores from several other
worksheets.

Problem is... the other worksheets change order depending on top score
(which I sort manually), so I can't put in an absolute reference to the
other
worksheet cells, because it would give me the wrong number.

Barb, you could use a formula something like this



=SUMIF('Bull Riding'!$A$2:$A$10,Totals!$A2,'Bull Riding'!$B$2:$B$10)



Where your names are in Bull Riding A2:A10 totals are in B2:B10 and the name
you want to get the total for is in Totals A2



You might want to consider changing the way you have your data setup, you
could add a column for event and then put all the data in one sheet, then
you could sort and filter the data by what you wanted to and you could also
use a pivot table to look at the data different ways, like persons name,
event, and totals
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"Barb" wrote in message
...
I couldn't get to the webpage you suggested, so here's another version of
my
problem.

Rodeo Scores
Cowboys ride in different events, therefore each tab is an event with name
and score.
Example:
Tab - Bull Riding (Event) (Event Dates)
Total 4/1 4/2 5/1 5/2 6/6
6/7
Cowboy 1 58 10 9 10 9 10
10
Cowboy 2 57 9 10 10 9 9
10

Tab - Bare Back (Event) (Event Dates)
Total 4/1 4/2 5/1 5/2 6/6
6/7 7/6 7/7
Cowboy 2 57 9 9 10 9 10
10
Cowboy 1 56 9 10 10 9 8
10

Tab - Totals
Bull Riding Bare Back
Cowboy 1 58 56
Cowboy 2 57 57

I'm trying to create a 'totals' tab with total score for each event.
However, when I manually sort the 'event' tab, ranking the highest score
at
the top, this changes the cells that I've referenced my 'total' worksheet
to.

Thanks for your time... it's really appreciated!


"Paul B" wrote:

Barb, when you said "sort manually" I thought you were sorting the
worksheet
tabs, my bad, have a look at index and match here and see if this will
work
for you http://www.contextures.com/xlFunctions03.html if not you may
want
to post back with more information on how your workbook is set up and
what
you want it to do.
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Barb" wrote in message
...
It doesn't, because as soon as I sort the individual score worksheet,
the
totals worksheet pulls the data from the !A1 cell, which now has
another
contestants name.

What about naming the cells, and doing something with that???

"Paul B" wrote:

Barb, something like this should work, =Sheet2!A1
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from
it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Barb" wrote in message
...
I have 1 worksheet that needs to pull the scores from several other
worksheets.

Problem is... the other worksheets change order depending on top
score
(which I sort manually), so I can't put in an absolute reference to
the
other
worksheet cells, because it would give me the wrong number.