Collecting data on web in Excel

  • Thread starter Thread starter Andrew J
  • Start date Start date
A

Andrew J

I have a requirement where information is periodically
requested from head office in each country in the
organisation. Currently, Excel files are sent to each
country & they enter the requested info & return it where
we then have to consolidate the data (a pain). To
streamline this I want to publish an Excel sheet on an
intranet page and then get each country to enter their
data. I don't want users from one country to see data
from another. I then want to retrieve that sheet and have
the data from each country on a separate sheet (tab). Is
this easy to do, or not possible?

Thanks in advance.
 
I have a requirement where information is periodically
requested from head office in each country in the
organisation. Currently, Excel files are sent to each
country & they enter the requested info & return it where
we then have to consolidate the data (a pain). To
streamline this I want to publish an Excel sheet on an
intranet page and then get each country to enter their
data. I don't want users from one country to see data
from another. I then want to retrieve that sheet and have
the data from each country on a separate sheet (tab). Is
this easy to do, or not possible?
Click to expand...

Somewhere in between. It is definitely possible, but not entirely easy.

- I see that you want the end result to be Excel, but do you require that
your users enter their data into Excel or could you change to entering
data into a form on a webpage?

My idea is that you'll end up with a bunch of text files, one for each
country. Those can be easily imported into Excel, one sheet per
textfile. You could even automate the process with a macro.

How we get those textfiles is another story. A possible option is to
require that each user, after entering data into Excel, export the
information to a textfile (named appropriately).

Another option is for users to enter the data onto a webpage. But this
requires that you have privileges to run scripts on the webserver.

Does any of this sound workable?
 
Back
Top