Excel Problem

[TheeOx]

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:

 

[brady]

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 ?

 

[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.

 

[TheeOx]

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 :