![]() |
2010-12-24
, 18:43
|
Posts: 22 |
Thanked: 1 time |
Joined on Dec 2010
|
#461
|
![]() |
2010-12-24
, 23:10
|
Posts: 12 |
Thanked: 0 times |
Joined on Dec 2010
|
#462
|
![]() |
2010-12-24
, 23:25
|
Posts: 18 |
Thanked: 2 times |
Joined on Dec 2010
|
#463
|
![]() |
2010-12-25
, 00:13
|
Posts: 22 |
Thanked: 1 time |
Joined on Dec 2010
|
#464
|
![]() |
2010-12-25
, 02:25
|
Posts: 43 |
Thanked: 2 times |
Joined on Nov 2010
|
#465
|
![]() |
2010-12-25
, 03:25
|
Posts: 12 |
Thanked: 0 times |
Joined on Dec 2010
|
#466
|
![]() |
2010-12-25
, 03:44
|
Posts: 43 |
Thanked: 2 times |
Joined on Nov 2010
|
#467
|
![]() |
2010-12-25
, 08:33
|
Posts: 18 |
Thanked: 2 times |
Joined on Dec 2010
|
#468
|
Can Excel pull values from a one spreadsheet's cells to calculate numbers in a different one? AFAIK, this isn't possible. It's easily done on the same spreadsheet which is why your totals and the averages autoupdate in the main spreadsheet (when configured properly), but the league spreadsheet is seperate, only stored at the same url. If the league scores were at the bottom of the main spreadsheet, it could autoupdate, but its a lot easier to access as it is.
![]() |
2010-12-25
, 09:40
|
Posts: 43 |
Thanked: 2 times |
Joined on Nov 2010
|
#469
|
![]() |
2010-12-25
, 09:59
|
Posts: 92 |
Thanked: 7 times |
Joined on Dec 2010
|
#470
|
Done. Only up to 5 columns can be locked so I had to delete the filler columns but it still looks neat. Now to work on becoming above average
Another spreadsheet for seasons isn't necessary, seeing as there's only 1 day left (not including today). But perhaps we should make one for the new "Ham 'Em High" episode, and then transfer the results to the main spreadsheet once a newer episode is released.
![]() |
Tags |
bada blows, bada rox |
Thread Tools | |
|