Excel Problem - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Microsoft Windows and Software
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 09-09-2005, 07:29 PM   #1 (permalink)
Junior Techie
 
Join Date: Sep 2004
Location: Hi
Posts: 60
Send a message via AIM to TheeOx
Default Excel Problem

Hi all,

Does Excel have the capability to link excel spreadsheets to a master spreadsheet via personal computers?
Here's a better description:
There is one master Excel spreadsheet on one PC.
Several other people have weekly spreadsheets that they will fill out. Can the employee spreadsheets be linked to automatically update on the master spreadsheet?
I have been searching high and low but to no avail.

I really need help on this one.

Thanks,
Thee:beard:
__________________

__________________
If you love a PC, set it free. If the relationship was meant to be, the PC will return. If the PC wont come back, track it down and smash it into a million pieces.
TheeOx is offline  
Old 09-09-2005, 07:51 PM   #2 (permalink)
S e c u r e d
 
Join Date: Feb 2005
Location: Somewhere Sunny
Posts: 3,760
Default

These Entries all go into the Master Excel sheet ?
or are they different Files that you would like set as, lets say pages.
So when they save that particular file it automatically links itself to that
"Master" doc as an alternate page ?
__________________

__________________
brady is offline  
Old 09-09-2005, 09:54 PM   #3 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default

you could use odbc to update the master spreadsheet from the employee sheets. a script would have to be executed for the sheet to be updated.

gimmie a better idea of what you want to happen and when i get some time, i could bang out the code.
office politics is offline  
Old 09-09-2005, 10:47 PM   #4 (permalink)
Junior Techie
 
Join Date: Sep 2004
Location: Hi
Posts: 60
Send a message via AIM to TheeOx
Default Cool

Thanks...I shall get back to you soon.
Dunno what the data will be...but Ill find out.

Thanks again for wanting to bang out that code.
That will save my heiny.
Later,
Thee :
TheeOx is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off




Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 05:36 AM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.