I'm not sure where to post this to get the answer I'm looking for....
Problem: I have offices statewide who keep individual Excel Workbooks with
multiple sheets relating to individual clients... they also keep a progress
sheet which is updated automatically as they update individual client
files... this happens within the one workbook that is open at the time....
presently I have to get them to individually email me the sheet or workbook
to look at it centrally. This seems inefficient as I would like to be able
to look at the data for all offices at any time.

Can someone give me some ideas as to how this can be accomplished?

plato

plato wrote

> I'm not sure where to post this to get the answer I'm looking for....
> Problem: I have offices statewide who keep individual Excel Workbooks
> with multiple sheets relating to individual clients... they also keep
> a progress sheet which is updated automatically as they update
> individual client files... this happens within the one workbook that
> is open at the time.... presently I have to get them to individually
> email me the sheet or workbook to look at it centrally. This seems
> inefficient as I would like to be able to look at the data for all
> offices at any time.
>
> Can someone give me some ideas as to how this can be accomplished?

Don't you have a network?  Then everyone could access a master workbook.

--
Charles Sweeney
http://CharlesSweeney.com

"plato" <platoTAKETHISOUT@telpacific.com.au> wrote in
news:4486b14f@news.rivernet.com.au:

> I'm not sure where to post this to get the answer I'm looking
> for.... Problem: I have offices statewide who keep individual Excel
> Workbooks with multiple sheets relating to individual clients...
> they also keep a progress sheet which is updated automatically as
> they update individual client files... this happens within the one
> workbook that is open at the time.... presently I have to get them
> to individually email me the sheet or workbook to look at it
> centrally. This seems inefficient as I would like to be able to look
> at the data for all offices at any time.
>
> Can someone give me some ideas as to how this can be accomplished?
>
> plato

Sounds like you need a web application instead of Excel.

--
Stan McCann "Uncle Pirate" http://stanmccann.us/pirate.html
Webmaster/Computer Center Manager, NMSU at Alamogordo
Webmaster, ABATE of NM;  AMA#758681; COBB
'94 1500 Vulcan (now wrecked) :( http://motorcyclefun.org/Dcp_2068c.jpg
A zest for living must include a willingness to die. - R.A. Heinlein

Fleeing from the madness of the  jungle
plato <platoTAKETHISOUT@telpacific.com.au> stumbled into
news:alt.www.webmaster
and said:

> I'm not sure where to post this to get the answer I'm looking for....
> Problem: I have offices statewide who keep individual Excel Workbooks
> with
> multiple sheets relating to individual clients... they also keep a
> progress
> sheet which is updated automatically as they update individual client
> files... this happens within the one workbook that is open at the
> time....
> presently I have to get them to individually email me the sheet or
> workbook
> to look at it centrally. This seems inefficient as I would like to be
> able
> to look at the data for all offices at any time.
>
> Can someone give me some ideas as to how this can be accomplished?

oh my my - the joys of distributed data.

How up-to-date do you need?  week, day, real-time?

Makes a difference to the options.  Also, the closer you get to real time,
the more impact any new system will have on current practice.

--
William Tasso

http://williamtasso.com/words/what-is-usenet.asp