Our new Indie Games subforum is now open for business in G&T. Go and check it out, you might land a code for a free game. If you're developing an indie game and want to post about it, follow these directions. If you don't, he'll break your legs! Hahaha! Seriously though.
Our rules have been updated and given their own forum. Go and look at them! They are nice, and there may be new ones that you didn't know about! Hooray for rules! Hooray for The System! Hooray for Conforming!
I have a quick question concerning Excel. At work I maintain a spreadsheet of all the company's clients and the progress that we make for each one. Essentially, I keep a huge sheet with all sorts of information that each week my boss wants specific versions of this sheet as a report. This means that I spend an immense amount of time each week cutting and pasting my big spreadsheet into lots of little spreadsheets (there are eight versions I currently have to produce) and then distribute them to each member of our staff based on their responsibility.
Now, I was wondering if there was any way to make Excel auto-populate these reports for me. In my mind, and I don't have any sort of formal Excel instruction, it seems like I could set the spreadsheet to automatically pop things into different tabs, i.e. if a client record is marked as "closed", that same entry would pop up under a tab marked "closed". Now, I'm not certain that Excel could even do such a thing, can it?
This isn't a do-or-die, but these weekly reports are getting quite unwieldy and errors inevitably pop up from time to time as I dissect and reassemble these spreadsheets on a weekly basis. If I can't make this process easier through Excel, I'm sure I can convince my boss to spring for tracking software, but a client-tracker in Excel that I have control over is far more appealing than the software that's out there.
Any help would be appreciated. My Google-Fu has come up with very little, mostly because I'm uncertain exactly what I'm even looking for.