Eh guys- first post. I'm a little out of whack with the exact terminology of the functions I'm looking for so I figured I'd come in here and describe what I'm hoping to be able to do. Maybe someone can at least point me in the right direction for searching the site.


Basically, the paperwork around here and all the individual reports is ridiculous. You put down all the information for the day, every single day and at the end of the month you have 3 or more different reports that you need to write that describes everything you've done. So as an example- Training. We are training or working on tactics just about every day of the shift. I enter these sessions in our daily log as whatever we were training on and for how long. Then I have to go back in at the end of the month, read through every daily log and account for the training that was done. Guys on 4 different shifts are all doing the same thing, submitting monthly summaries, training records, standby's- etc.

Stupid, and wasteful of time and paper.

What I'm wondering is if EXCEL has the functonality to automatically take entries from one area and enter them into a separate file or another tab. Or is there another program out there within the microsoft group that would work better?