Any Excel Wizards? | |
 |
| | Thread Tools | Display Modes |
| |
| |||||||
02-07-2005
| #1 | ||
| Nasty Dish Obsession  Join Date: 01-06-2004 Location: Oxfordshire
Posts: 3587
Thanks: 4
Thanked 10 Times in 10 Posts
My System: SS1. 3.4Ghz Dual Core P4. 125cm Gibbi with Channelmaster feedhorn and Inverto C120 twin. 36v H to H  ...And thou were the truest friend to thy lover that ever bestrad horse..." |
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.  | ||
|  |
|
02-07-2005
| #2 | ||
| Ding Dang Doo  Join Date: 31-01-2004 Location: Scotland
Posts: 4285
Thanks: 1
Thanked 0 Times in 0 Posts
My System: DreamBox 7000s - Nokia Freeview - Several GameBoys - DS Lite - ZX81 - SNES - N64 - Sega Saturn Dreamcast - PlayStation - Gamecube - PSP - iPod - iPhone - XBox - PS3 - Wii - No Life! | 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.
__________________  Only he who does nothing, does nothing wrong. | ||
|
| |
|
02-07-2005
| #3 | ||
| Nasty Dish Obsession Join Date: 01-06-2004 Location: Oxfordshire
Posts: 3587
Thanks: 4
Thanked 10 Times in 10 Posts
My System: SS1. 3.4Ghz Dual Core P4. 125cm Gibbi with Channelmaster feedhorn and Inverto C120 twin. 36v H to H ...And thou were the truest friend to thy lover that ever bestrad horse..." | Brill cheers gb  L. | ||
|
| |
|
06-07-2008
| #4 | |||
| can't spell :D  Join Date: 26-10-2004 Location: Colchester, Essex
Posts: 1774
Thanks: 121
Thanked 28 Times in 25 Posts
My System: Sky+ Pace v3, and before that analouge 80cm dish with Prima by Pace box pointed at 19.2e (not very imaginative then!) | 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.
__________________ | |||
|
| |
|
06-07-2008
| #5 | ||
| Super Moderator  Join Date: 08-03-2005 Location: J6 M5
Posts: 3561
Thanks: 3
Thanked 94 Times in 90 Posts
Blog Entries: 1 My System: DM7020S ~ DM500s ~ sg2100 ~ Gemini  If he were not a wizard, from head down to the root, you would have got to worry-your DB only boots | 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  | ||
|
| |
|
06-07-2008
| #6 | ||
| Amo Amas Amant Admin  Join Date: 18-11-2004 Location: NW England (Siberia)
Posts: 7500
Thanks: 15
Thanked 196 Times in 183 Posts
My System: IDD CI24 ECONO MM Penta 1.20 Galaxy II 1.2Mtr Polar MTG yes it has been on the arc for 21 years and is still driven by a modified wiper motor from a Ford Anglia. It's like me sometimes groans but always performs  Saved us from the black plague of ignoratio elenchi, he awaits a special badge with jugs |
Post a copy of the file Salty............
__________________ War does not determine who is right, it determines who is left! Formerly toppervte33h whose six pack has turned into a keg Help support this web site by making a donation Or use other options to help support Sats UK Show Your Support by clicking the button  Thank you. Freddie Flintoff is back | ||
|
| |
|
06-07-2008
| #7 | |||
| can't spell :D Join Date: 26-10-2004 Location: Colchester, Essex
Posts: 1774
Thanks: 121
Thanked 28 Times in 25 Posts
My System: Sky+ Pace v3, and before that analouge 80cm dish with Prima by Pace box pointed at 19.2e (not very imaginative then!) | 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.)
__________________ | |||
|
| |
|
06-07-2008
| #8 | ||
| Amo Amas Amant Admin Join Date: 18-11-2004 Location: NW England (Siberia)
Posts: 7500
Thanks: 15
Thanked 196 Times in 183 Posts
My System: IDD CI24 ECONO MM Penta 1.20 Galaxy II 1.2Mtr Polar MTG yes it has been on the arc for 21 years and is still driven by a modified wiper motor from a Ford Anglia. It's like me sometimes groans but always performs Saved us from the black plague of ignoratio elenchi, he awaits a special badge with jugs |
OK leave it with me... are you in a rush for it
__________________ War does not determine who is right, it determines who is left! Formerly toppervte33h whose six pack has turned into a keg Help support this web site by making a donation Or use other options to help support Sats UK Show Your Support by clicking the button Thank you. Freddie Flintoff is back | ||
|
| |
|
07-07-2008
| #9 | ||||
| can't spell :D Join Date: 26-10-2004 Location: Colchester, Essex
Posts: 1774
Thanks: 121
Thanked 28 Times in 25 Posts
My System: Sky+ Pace v3, and before that analouge 80cm dish with Prima by Pace box pointed at 19.2e (not very imaginative then!) |
the league doesn't until August, but I like to have everything in place.
__________________ | ||||
|
| |
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Vamos Aprender Para Ser Mais Fácil! | mamsilva | Assuntos Gerais | 3 | 01-06-2006 10:51 AM |
| Excel help please | dynamo985 | Computer Discussion | 3 | 17-11-2004 12:00 AM |
| Excel and Time Calculations | w hole |  The Meeting Place | 9 | 14-12-2001 01:25 PM |
| Wizard's back on line | 2old4this | Announcements and News | 0 | 17-07-2001 05:05 PM |
Linear Mode
