MS Excel nerdery

[Woden]

So I have an 8 hour shift and literery no work to do, at all. So a good time to make a start and improve some of the stuff we use on a day to day basis.

Basically we have to log all unschedualed returns. So we have an excel spreadsheet, one for each year with a tab for the contracts list, then one for each month. We basically keep track with rows that list things like date, shift, tracking number, etc. Problem is the file is getting massive. its almost 3MB now and these PC's aren't exactly beasty.

There has to be a better way. I dont have access to C++/c# at work just Office (no Access unfortunately) and VBA. File locking on the shared drive isnt ideal either.

Any ideas? This could actually be usefull as I havn't had any experiance of VBA since I left uni, and that was very limited.

 

[Woden]

3MB is massive on a machine with 512MB of ram, at least with all the other stuff I need open at the same time. When I told IT I needed to have a lot of stuff open at once, they gave me a new monitor :| (23" 1080p though, not bad to be fair!)

Yea, Access was my first solution but the IT guys wont install it for us for some reason. Most of the time all we are doing is adding a new entry, its very rare we have to look back at older entries, and obviously we *never* edit old entries, that would defy the point.

ATM (well not ATM im not in work) I am making a new spreadsheet with fewer contract numbers, almost 10k contracts but most clients have a whole bunch, so we don't need them all in this file.

I'm guessing if I make a frontend, I can have drop down boxes that select a client, and fills in contract number by pulling it from that list? Then date/shift can be automagic. All they would have to type then is description, tracking number and name.