docjackson33
New Member
- Joined
- Feb 7, 2010
- Messages
- 18
Hello All,
My issue is doing analysis w/in a tight timeline, and before that can be done, the Main spreadsheet must first be updated by hand. Being that this spread sheet is comprised of over 50 different MOS types, x6 companies, it becomes very tedeous and time consuming. I have finally added a formula that will pull the additional gains =COUNTIF('Gains'!$D$2:$D$30,A11) and losses =COUNTIF('Losses'!$D$2:$D$8,A2) (from different tabs) into this spreadsheet. My goal is to have a macro do this, because there may be a variable that would cause me to remove the formula from that cell. I've attempted to use jeanie and show the 3 phases of my head ache, but no avail. Sorry, here's what I need. I need the macro to look in the "gains tab" to find all of the MOS(s) listed in the "MOS" column, by "Unit", by "Report Dt" (note: this is the date format20100616). With that, I need it need only grab MOS(s) w/in 120 days of the present month, eg. there are x3 21B, but only two have a report date before Nov 10 or 20101116, so it will go to the "Main spreadsheet" find the apropriate "Unit", and "MOS"(21B, 74D, etc) and input the number 2 in the gains column under the apropriate company and to the right of that MOS. And then repeat the same action for the "Loss" tab and column. I hope this is understandable.
Thanks in advance...
Jonathan
"Living the Army Dream"
My issue is doing analysis w/in a tight timeline, and before that can be done, the Main spreadsheet must first be updated by hand. Being that this spread sheet is comprised of over 50 different MOS types, x6 companies, it becomes very tedeous and time consuming. I have finally added a formula that will pull the additional gains =COUNTIF('Gains'!$D$2:$D$30,A11) and losses =COUNTIF('Losses'!$D$2:$D$8,A2) (from different tabs) into this spreadsheet. My goal is to have a macro do this, because there may be a variable that would cause me to remove the formula from that cell. I've attempted to use jeanie and show the 3 phases of my head ache, but no avail. Sorry, here's what I need. I need the macro to look in the "gains tab" to find all of the MOS(s) listed in the "MOS" column, by "Unit", by "Report Dt" (note: this is the date format20100616). With that, I need it need only grab MOS(s) w/in 120 days of the present month, eg. there are x3 21B, but only two have a report date before Nov 10 or 20101116, so it will go to the "Main spreadsheet" find the apropriate "Unit", and "MOS"(21B, 74D, etc) and input the number 2 in the gains column under the apropriate company and to the right of that MOS. And then repeat the same action for the "Loss" tab and column. I hope this is understandable.
Thanks in advance...
Jonathan
"Living the Army Dream"
