I have just started using excel and have made my first real
spreadsheet with 12 seperate sheets.
I have managed to automatically transfer results between sheets but i
want to go up a level.
My idea is to allow the user to input a name in one sheet and for this
data to be automatically recognised in a seperate sheet and
automatically updated.
Example : sheet 1 is the result sheet
sheet 2 contains 15 "heat results" allowing the user
to input points that are automatically added together and displayed
both in sheet 1 and sheet 2

Now the hard part

After the 15 heats the top 8 "scorers" are then put into 2 semi final
heats and this is where i need help

The user will input or select a "name" in sheet 2 and will add his
"score" in the same sheet and i want these scores to be automatically
added to sheet 1

Is this possible?

Don't know if it helps you or not but a quick Google web search
2003 Cheddar Cheese Challenge HPV Racing Results
http://www.wisil.recumbents.com/wisi...03_results.htm
at the bottom you will see that an Excel spreadsheet has additional
information. My search arguments were something like:
excel lap OR heat race -hth

Anyone else who wants to answer should also be aware that the
poster also posted in public.excel
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"PGM" wrote in message ...
I have just started using excel and have made my first real
spreadsheet with 12 seperate sheets.
I have managed to automatically transfer results between sheets but i
want to go up a level.
My idea is to allow the user to input a name in one sheet and for this
data to be automatically recognised in a seperate sheet and
automatically updated.
Example : sheet 1 is the result sheet
sheet 2 contains 15 "heat results" allowing the user
to input points that are automatically added together and displayed
both in sheet 1 and sheet 2

Now the hard part

After the 15 heats the top 8 "scorers" are then put into 2 semi final
heats and this is where i need help

The user will input or select a "name" in sheet 2 and will add his
"score" in the same sheet and i want these scores to be automatically
added to sheet 1

Is this possible?