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.