|
Ugh, I have no idea how to do what your talking about in excel. Sorry man.
Depending on how important it is, you could go the route of MySQL like I said. It would be relatively easy to have one comp on the intranet running SQL, and have the workers fill out a page and store their info on the server instead of locally. The page could be built in ASP or PHP, and have a form to enter all of the data they are currently putting in excel. Then you could easily create another page that queries the database to your hearts content.
This maybe overkill, but it would certainly solve the problem, and keep everything in a central database that could easily be backed up, or migrated.
Good luck to you, and if you need any other help feel free to PM me.
P.S. sorry, you posted the part about 'not wanting to change anything' while I was typing. good luck.
|