software

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 amp; 2003

quot;Barbquot; gt; wrote in message
...
gt;I have 1 worksheet that needs to pull the scores from several other
gt;worksheets.
gt;
gt; Problem is... the other worksheets change order depending on top score
gt; (which I sort manually), so I can't put in an absolute reference to the
gt; other
gt; worksheet cells, because it would give me the wrong number.
gt;
gt;
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???

quot;Paul Bquot; wrote:

gt; Barb, something like this should work, =Sheet2!A1
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Barbquot; gt; wrote in message
gt; ...
gt; gt;I have 1 worksheet that needs to pull the scores from several other
gt; gt;worksheets.
gt; gt;
gt; gt; Problem is... the other worksheets change order depending on top score
gt; gt; (which I sort manually), so I can't put in an absolute reference to the
gt; gt; other
gt; gt; worksheet cells, because it would give me the wrong number.
gt; gt;
gt; gt;
gt;
gt;
gt;

Barb, when you said quot;sort manuallyquot; 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 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 amp; 2003

quot;Barbquot; gt; wrote in message
...
gt; It doesn't, because as soon as I sort the individual score worksheet, the
gt; totals worksheet pulls the data from the !A1 cell, which now has another
gt; contestants name.
gt;
gt; What about naming the cells, and doing something with that???
gt;
gt; quot;Paul Bquot; wrote:
gt;
gt;gt; Barb, something like this should work, =Sheet2!A1
gt;gt; --
gt;gt; Paul B
gt;gt; Always backup your data before trying something new
gt;gt; Please post any response to the newsgroups so others can benefit from it
gt;gt; Feedback on answers is always appreciated!
gt;gt; Using Excel 2002 amp; 2003
gt;gt;
gt;gt; quot;Barbquot; gt; wrote in message
gt;gt; ...
gt;gt; gt;I have 1 worksheet that needs to pull the scores from several other
gt;gt; gt;worksheets.
gt;gt; gt;
gt;gt; gt; Problem is... the other worksheets change order depending on top score
gt;gt; gt; (which I sort manually), so I can't put in an absolute reference to the
gt;gt; gt; other
gt;gt; gt; worksheet cells, because it would give me the wrong number.
gt;gt; gt;
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
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!quot;Paul Bquot; wrote:

gt; Barb, when you said quot;sort manuallyquot; I thought you were sorting the worksheet
gt; tabs, my bad, have a look at index and match here and see if this will work
gt; for you www.contextures.com/xlFunctions03.html if not you may want
gt; to post back with more information on how your workbook is set up and what
gt; you want it to do.
gt; --
gt; Paul B
gt; Always backup your data before trying something new
gt; Please post any response to the newsgroups so others can benefit from it
gt; Feedback on answers is always appreciated!
gt; Using Excel 2002 amp; 2003
gt;
gt; quot;Barbquot; gt; wrote in message
gt; ...
gt; gt; It doesn't, because as soon as I sort the individual score worksheet, the
gt; gt; totals worksheet pulls the data from the !A1 cell, which now has another
gt; gt; contestants name.
gt; gt;
gt; gt; What about naming the cells, and doing something with that???
gt; gt;
gt; gt; quot;Paul Bquot; wrote:
gt; gt;
gt; gt;gt; Barb, something like this should work, =Sheet2!A1
gt; gt;gt; --
gt; gt;gt; Paul B
gt; gt;gt; Always backup your data before trying something new
gt; gt;gt; Please post any response to the newsgroups so others can benefit from it
gt; gt;gt; Feedback on answers is always appreciated!
gt; gt;gt; Using Excel 2002 amp; 2003
gt; gt;gt;
gt; gt;gt; quot;Barbquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt;I have 1 worksheet that needs to pull the scores from several other
gt; gt;gt; gt;worksheets.
gt; gt;gt; gt;
gt; gt;gt; gt; Problem is... the other worksheets change order depending on top score
gt; gt;gt; gt; (which I sort manually), so I can't put in an absolute reference to the
gt; gt;gt; gt; other
gt; gt;gt; gt; worksheet cells, because it would give me the wrong number.
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

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 amp; 2003quot;Barbquot; gt; wrote in message
...
gt;I couldn't get to the webpage you suggested, so here's another version of
gt;my
gt; problem.
gt;
gt; Rodeo Scores
gt; Cowboys ride in different events, therefore each tab is an event with name
gt; and score.
gt; Example:
gt; Tab - Bull Riding (Event) (Event Dates)
gt; Total 4/1 4/2 5/1 5/2 6/6
gt; 6/7
gt; Cowboy 1 58 10 9 10 9 10
gt; 10
gt; Cowboy 2 57 9 10 10 9 9
gt; 10
gt;
gt; Tab - Bare Back (Event) (Event Dates)
gt; Total 4/1 4/2 5/1 5/2 6/6
gt; 6/7 7/6 7/7
gt; Cowboy 2 57 9 9 10 9 10
gt; 10
gt; Cowboy 1 56 9 10 10 9 8
gt; 10
gt;
gt; Tab - Totals
gt; Bull Riding Bare Back
gt; Cowboy 1 58 56
gt; Cowboy 2 57 57
gt;
gt; I'm trying to create a 'totals' tab with total score for each event.
gt; However, when I manually sort the 'event' tab, ranking the highest score
gt; at
gt; the top, this changes the cells that I've referenced my 'total' worksheet
gt; to.
gt;
gt; Thanks for your time... it's really appreciated!
gt;
gt;
gt; quot;Paul Bquot; wrote:
gt;
gt;gt; Barb, when you said quot;sort manuallyquot; I thought you were sorting the
gt;gt; worksheet
gt;gt; tabs, my bad, have a look at index and match here and see if this will
gt;gt; work
gt;gt; for you www.contextures.com/xlFunctions03.html if not you may
gt;gt; want
gt;gt; to post back with more information on how your workbook is set up and
gt;gt; what
gt;gt; you want it to do.
gt;gt; --
gt;gt; Paul B
gt;gt; Always backup your data before trying something new
gt;gt; Please post any response to the newsgroups so others can benefit from it
gt;gt; Feedback on answers is always appreciated!
gt;gt; Using Excel 2002 amp; 2003
gt;gt;
gt;gt; quot;Barbquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; It doesn't, because as soon as I sort the individual score worksheet,
gt;gt; gt; the
gt;gt; gt; totals worksheet pulls the data from the !A1 cell, which now has
gt;gt; gt; another
gt;gt; gt; contestants name.
gt;gt; gt;
gt;gt; gt; What about naming the cells, and doing something with that???
gt;gt; gt;
gt;gt; gt; quot;Paul Bquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; Barb, something like this should work, =Sheet2!A1
gt;gt; gt;gt; --
gt;gt; gt;gt; Paul B
gt;gt; gt;gt; Always backup your data before trying something new
gt;gt; gt;gt; Please post any response to the newsgroups so others can benefit from
gt;gt; gt;gt; it
gt;gt; gt;gt; Feedback on answers is always appreciated!
gt;gt; gt;gt; Using Excel 2002 amp; 2003
gt;gt; gt;gt;
gt;gt; gt;gt; quot;Barbquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt;I have 1 worksheet that needs to pull the scores from several other
gt;gt; gt;gt; gt;worksheets.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Problem is... the other worksheets change order depending on top
gt;gt; gt;gt; gt; score
gt;gt; gt;gt; gt; (which I sort manually), so I can't put in an absolute reference to
gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt; other
gt;gt; gt;gt; gt; worksheet cells, because it would give me the wrong number.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;