rero360
09-09-2015, 10:25 PM
Good Evening everyone, I am hoping I could get some help. I want to create a workbook that updates every time it is opened. What I'm trying to do is track everyone in my company, when they enlisted or commissioned, so that when the workbook is opened, it updates and on sheet 1 says who has earned what awards. Some military awards are earned after various periods of good service, one year for one, three years for others, ten years for others still. What I'd like it to do is when it opens sheet one becomes populated with the names of everyone who earned an award that month, and then shows what awards and finally, has a list of total longevity awards.
For example, workbook is opened (in Sept 2015), on sheet 1 it lists:
-------------CADAR--- CASM--- CAGCM--- ARCAM --- AFRM-------- CADAR --- CASM ---CAGCM ---ARCAM--- AFRM
E4 Snuffy, Joe - X----------------- X-------- X ----------------------6--------- 0--------- 2-------- 2-------- 0
enlisted Sept 5 2009(this would stay on sheet 3)
O2 Dix, Richard - X-------------------------------------------------- 4----------0--------- 1--------- 1--------0
commissioned Sept 29 2011
Is this possible? And if so, what would be starting point to get it to calculate everything off of the computer's date? I'm currently taking a VBA course but its geared towards engineering and the professor said that we wouldn't be covering anything like this. My admin people are horribly understaffed and I want to create something that will speed up at least one task for them. Finally, how intensive of a code is this going to be?
Thank you everyone.
For example, workbook is opened (in Sept 2015), on sheet 1 it lists:
-------------CADAR--- CASM--- CAGCM--- ARCAM --- AFRM-------- CADAR --- CASM ---CAGCM ---ARCAM--- AFRM
E4 Snuffy, Joe - X----------------- X-------- X ----------------------6--------- 0--------- 2-------- 2-------- 0
enlisted Sept 5 2009(this would stay on sheet 3)
O2 Dix, Richard - X-------------------------------------------------- 4----------0--------- 1--------- 1--------0
commissioned Sept 29 2011
Is this possible? And if so, what would be starting point to get it to calculate everything off of the computer's date? I'm currently taking a VBA course but its geared towards engineering and the professor said that we wouldn't be covering anything like this. My admin people are horribly understaffed and I want to create something that will speed up at least one task for them. Finally, how intensive of a code is this going to be?
Thank you everyone.