I would like to design an excel workbook to track leave for Soldiers in an effort to make sure that I have sufficient manpower to complete all my missions. I would like it to do the following:
1. On sheet 1, input rank and name, leave start and end dates 2. Pass this information into a calendar on sheet 2 (already created) by adding Soldier info to all days on which Soldier will be on leave 3. Subtract number of Soldiers who are on leave on a given date from pool of available Soldiers which I can place either on sheet 1 or another sheet 4. Compare Soldiers not on leave to manpower requirements to complete platoon's missions and give either a YES or NO response to whether we are mission capable. I am currently deployed to Iraq and as you can imagine, do not have a whole lot of time to try to figure this out alone so I am asking the experts for help. Any that you can give will be greatly appreciated by me and my Soldiers. --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
