Any Excel Wizards?

Lancelot

Retired Mod
Joined
Jun 1, 2004
Messages
3,639
Reaction score
10
Points
38
My Satellite Setup
SS1.
125cm Gibbi with Channelmaster feedhorn and Inverto C120 twin.
36v H to H 62E - 61.5W
My Location
South central
Hi guys - trying to auto update an XL spreadsheet from another computer on the network without using manual refresh ( sort of like the remote assistance tool where you type on one and see it on the other)

Is this at all possible ??


Cheers

L. :)
 

gameboy

Ding Dang Doo
Joined
Jan 31, 2004
Messages
4,305
Reaction score
6
Points
38
Age
67
Website
www.gamezplay.org
My Satellite Setup
DreamBox 7000s - Nokia Freeview - Several GameBoys - DS Lite - ZX81 - SNES - N64 - Saturn - Dreamcast - PlayStation - PS2 - Gamecube - PSP - iPod - iPhone - XBox - PS3 - Wii - iPad - No Life!
My Location
Scotland
Entering data into several Tables by Grouping Worksheets...

When creating worksheets which have the same structure and the same formulas in the same places, you should group them together before you enter data that is going to be identical in all tables. Then you only have to enter the data once, and it will automatically be entered into all the worksheets by Excel.
 

Lancelot

Retired Mod
Joined
Jun 1, 2004
Messages
3,639
Reaction score
10
Points
38
My Satellite Setup
SS1.
125cm Gibbi with Channelmaster feedhorn and Inverto C120 twin.
36v H to H 62E - 61.5W
My Location
South central
Brill cheers gb :D


L.
 

Salty25

Retired Mod
Joined
Oct 26, 2004
Messages
2,436
Reaction score
0
Points
0
Age
37
My Satellite Setup
Sky+ Pace v3, and before that analouge 80cm dish with Prima by Pace box pointed at 19.2e (not very imaginative then!)
My Location
Colchester, Essex
Thought I'd bump this up rather than make a new thread for a similar request. Basically I don't know how to do a formula so that I can make even better tables for the fantasy footie. I'm sure this is quite simple, but I don't quite know how to make it work. I have a draft excel file which you can play with to make it work.
 

mhku

Super Moderator
Staff member
Joined
Mar 8, 2005
Messages
4,712
Reaction score
20
Points
38
My Satellite Setup
TM Nano ~ sg2100
My Location
Midlands
To "make" a forumula type = (the equals symbol)

the cell with then get a slashed outline; use the arrow keys to highlight the required cell(s) and then choose your operator (+ - / *) etc.

google will probably give you a better answer with screenshots ;)
 

Topper

Amo Amas Amant Admin
Staff member
Joined
Nov 18, 2004
Messages
23,991
Reaction score
4,014
Points
113
Age
69
My Satellite Setup
Has gone to a good home elsewhere
My Location
Blackburn, Lancashire
Post a copy of the file Salty............
 

Salty25

Retired Mod
Joined
Oct 26, 2004
Messages
2,436
Reaction score
0
Points
0
Age
37
My Satellite Setup
Sky+ Pace v3, and before that analouge 80cm dish with Prima by Pace box pointed at 19.2e (not very imaginative then!)
My Location
Colchester, Essex
Basically, I can do the adding up of the points, that's pretty obvious! My problem come when I have to deduct the transfer penalties from the total. The rules on transfers is here - _http://fantasy.premierleague.com/M/help.mc?category=transfers. Just to add further complication, there is the wild card (which the page explains.

If you can get that to work, fantastic!

(BTW, don't worry about the 'positions' column when you go to sort it, that will move out of place but it's not important.)
 

Attachments

  • PLSL 0809 draft tab.zip
    3.2 KB · Views: 40

Topper

Amo Amas Amant Admin
Staff member
Joined
Nov 18, 2004
Messages
23,991
Reaction score
4,014
Points
113
Age
69
My Satellite Setup
Has gone to a good home elsewhere
My Location
Blackburn, Lancashire
OK leave it with me... are you in a rush for it
 

Salty25

Retired Mod
Joined
Oct 26, 2004
Messages
2,436
Reaction score
0
Points
0
Age
37
My Satellite Setup
Sky+ Pace v3, and before that analouge 80cm dish with Prima by Pace box pointed at 19.2e (not very imaginative then!)
My Location
Colchester, Essex
Topper said:
OK leave it with me... are you in a rush for it

Not particularly, leave until the weekend if you like :) the league doesn't until August, but I like to have everything in place.
 
Top