First thing I see here is that it sounds like you want to essentially create a database of records. If that's the case, Excel is not what you want for this, you really want a database.
I've built a lot of databases that use Excel as the front end, but I'd never try and link everyone in the office into a workbook on my PC. It's just too rife with perils for my taste.
If you're not afraid to learn, and you have the time to do so, I can certainly lead you along. It sounds like you've get a fairly clear idea of what you want, which is good, but you'd probably still need to flesh it out a bit more, and probably provide us some samples to get it working.
Basically what you'd need in order to do what I'm thinking is:
-A copy of Microsoft Access (or someone who can build the basic database -- providing it's not too complicated, I could help with that)
-An understanding of exactly what data needs to be captured
-An Excel template to capture your data
-A routine to push that data into the database (like this one here)
-A routine to pull the data from the database back to Excel (like this one)
With that, you can create a template that you can give to users. They can fill out the key pieces and upload new data into the database. You can then sort it however you like with a simple SQL query. In addition, you can also extract data, allow them to modify in Excel and re-upload. And you could also add the ability to remove an entry, but require a password to do so.
The benefits of the database are:
-That is what they are for
-You can then pull your data directly into PivotTables to report on it
-It's far less likely that someone will get into it and muck with it than a spreadsheet
Optionally, you could even role up your templates into a package, modify the ribbon and deploy it as an application quite easily.
I woudl certainly help you with this, but I'll warn you first that I'm busy, I'm not on everyday, and youd' be stuck with waiting for me if no one else came along to chip in.
Bookmarks