Moving to other worksheets
Posted by Roger on February 03, 2002 6:03 AM
I would like to know if there is a way to move a value from one worksheet and transfer it to another to be used in another set of calculations. An example would be to take all the rounds of golf I have on one worksheet and send them to another sheet and calculate the average.
Posted by Jack in the UK on February 03, 2002 10:06 AM
Try Vlookup, and calculate in the transfered data [NT]
Posted by Jack in the Uk on February 03, 2002 10:08 AM
Seems a lot of golfers about, Hawaii last. I have a sheet that does league table in Excel any good? [NT]
Posted by Vitellius on February 03, 2002 4:05 PM
If you have your scores in column A on Sheet1,
enter the following formula in any cell on another sheet (it will return your average score to one decimal place) :-
=ROUND(AVERAGE(Sheet1!A:A),1)
