Any Excel Wizards?

Lancelot

Specialist Contributor
Messages
3,638
Likes
8
My Satellite Setup
SS1.
125cm Gibbi with Channelmaster feedhorn and Inverto C120 twin.
36v H to H 62E - 61.5W
My Location
South central
#1
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
Messages
4,305
Likes
5
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
#2
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

Specialist Contributor
Messages
3,638
Likes
8
My Satellite Setup
SS1.
125cm Gibbi with Channelmaster feedhorn and Inverto C120 twin.
36v H to H 62E - 61.5W
My Location
South central
#3
Brill cheers gb :D


L.
 

Salty25

can't spell :D
Messages
2,436
Likes
0
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
#4
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
Messages
4,712
Likes
20
My Satellite Setup
TM Nano ~ sg2100
My Location
Midlands
#5
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
Messages
21,720
Likes
3,309
My Satellite Setup
IDD CI24 ECONO MM Penta 1.20 Galaxy II
1.2Mtr Polar MTG yes it has been on the arc for 25 years and is now fixed on 13 East using two pairs of rusty molegrips. Unlike me they never groan but always perform.
My Location
Blackburn, Lancashire
#6
Post a copy of the file Salty............
 

Salty25

can't spell :D
Messages
2,436
Likes
0
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
#7
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

Topper

Amo Amas Amant Admin
Staff member
Messages
21,720
Likes
3,309
My Satellite Setup
IDD CI24 ECONO MM Penta 1.20 Galaxy II
1.2Mtr Polar MTG yes it has been on the arc for 25 years and is now fixed on 13 East using two pairs of rusty molegrips. Unlike me they never groan but always perform.
My Location
Blackburn, Lancashire
#8
OK leave it with me... are you in a rush for it
 

Salty25

can't spell :D
Messages
2,436
Likes
0
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
#9
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