| Author |
Excel workbooks internet links...
|
|
|
| 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
| |
| Charles Sweeney 2006-06-08, 7:28 pm |
| 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
| |
| Uncle Pirate 2006-06-08, 7:28 pm |
| "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
| |
| William Tasso 2006-06-08, 7:28 pm |
| 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
|
|
|
|
| Copyright 2003 - 2008 forum4designers.com Software forum Computer Hardware reviews |