T
tropical_wolfpa
I'm trying to find a way that I can have people enter information in
spreadsheet, and then it automatically be refreshed to a blank form th
following week.
Here is the scenario. We operate a business with 8 locations connecte
by a WAN. Each week, I have a spreadsheet that I print and eac
location writes in the supplies they need. So all they key in i
really the quantity.
I want to make this spreadsheet accessable to them. I was hoping no
to actually install Excel on each station because of licensing and als
we have a problem with people using the computers for personal use an
this would be one more thing to have to monitor.
But the idea would be that they enter their supplies, and can update i
at any point up to a specified time. At that time, the files would b
automatically saved and copied under a name that specifies the date an
location initials. Then a new spreadsheet would be created and the
would be able to start entering supplies for the next week.
I'm not concerned with all this being accomplished in one workbook o
whether it is in one for each location. It would be nice for it to b
in one workbook because I could have it generate a picking list fo
that particular list on a combine sheet.
Can anyone point me in the right direction? Is excel the best choice?
Keep in mind that I'm trying to keep this really simple for developmen
and also for our users that are not that comfortable with computers.
Thanks for the hel
spreadsheet, and then it automatically be refreshed to a blank form th
following week.
Here is the scenario. We operate a business with 8 locations connecte
by a WAN. Each week, I have a spreadsheet that I print and eac
location writes in the supplies they need. So all they key in i
really the quantity.
I want to make this spreadsheet accessable to them. I was hoping no
to actually install Excel on each station because of licensing and als
we have a problem with people using the computers for personal use an
this would be one more thing to have to monitor.
But the idea would be that they enter their supplies, and can update i
at any point up to a specified time. At that time, the files would b
automatically saved and copied under a name that specifies the date an
location initials. Then a new spreadsheet would be created and the
would be able to start entering supplies for the next week.
I'm not concerned with all this being accomplished in one workbook o
whether it is in one for each location. It would be nice for it to b
in one workbook because I could have it generate a picking list fo
that particular list on a combine sheet.
Can anyone point me in the right direction? Is excel the best choice?
Keep in mind that I'm trying to keep this really simple for developmen
and also for our users that are not that comfortable with computers.
Thanks for the hel