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, 06: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.


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, 06:51 PM   #2 (permalink)
S e c u r e d
Join Date: Feb 2005
Location: Somewhere Sunny
Posts: 3,760

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, 08: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

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, 09: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.
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 09:10 PM.

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