Hi All,
I need to find the 1st & last mth for which the values is greater than zero. If the 1st mth with values is Jan and last mth is Oct (diff is 9 mths), it should copy to another workbook. If the first mth is Mar and last mth is Aug (diff is 5mths), then it should not copy. For the example below, it should copy Mango, Orange and Pear to Column A of the other workbook. Can anyone help with this? Thanks.
[TABLE="width: 849"]
<TBODY>[TR]
[TD]Product </SPAN>
[/TD]
[TD]Jan</SPAN>
[/TD]
[TD]Feb</SPAN>
[/TD]
[TD]Mar</SPAN>
[/TD]
[TD]Apr</SPAN>
[/TD]
[TD]May</SPAN>
[/TD]
[TD]Jun</SPAN>
[/TD]
[TD]Jul</SPAN>
[/TD]
[TD]Aug</SPAN>
[/TD]
[TD]Sep</SPAN>
[/TD]
[TD]Oct</SPAN>
[/TD]
[TD]Nov</SPAN>
[/TD]
[TD]Dec</SPAN>
[/TD]
[/TR]
[TR]
[TD]Mango</SPAN>
[/TD]
[TD="align: right"]50</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]41</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]84</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apple</SPAN>
[/TD]
[TD="align: right"]25</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orange</SPAN>
[/TD]
[TD="align: right"]75</SPAN>
[/TD]
[TD="align: right"]8</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]55</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pear</SPAN>
[/TD]
[TD="align: right"]63</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]6</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]21</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Avocado</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]52</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]32</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
I need to find the 1st & last mth for which the values is greater than zero. If the 1st mth with values is Jan and last mth is Oct (diff is 9 mths), it should copy to another workbook. If the first mth is Mar and last mth is Aug (diff is 5mths), then it should not copy. For the example below, it should copy Mango, Orange and Pear to Column A of the other workbook. Can anyone help with this? Thanks.
[TABLE="width: 849"]
<TBODY>[TR]
[TD]Product </SPAN>
[/TD]
[TD]Jan</SPAN>
[/TD]
[TD]Feb</SPAN>
[/TD]
[TD]Mar</SPAN>
[/TD]
[TD]Apr</SPAN>
[/TD]
[TD]May</SPAN>
[/TD]
[TD]Jun</SPAN>
[/TD]
[TD]Jul</SPAN>
[/TD]
[TD]Aug</SPAN>
[/TD]
[TD]Sep</SPAN>
[/TD]
[TD]Oct</SPAN>
[/TD]
[TD]Nov</SPAN>
[/TD]
[TD]Dec</SPAN>
[/TD]
[/TR]
[TR]
[TD]Mango</SPAN>
[/TD]
[TD="align: right"]50</SPAN>
[/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD="align: right"]41</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]84</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Apple</SPAN>
[/TD]
[TD="align: right"]25</SPAN>
[/TD]
[TD="align: right"]33</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]23</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Orange</SPAN>
[/TD]
[TD="align: right"]75</SPAN>
[/TD]
[TD="align: right"]8</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]55</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Pear</SPAN>
[/TD]
[TD="align: right"]63</SPAN>
[/TD]
[TD][/TD]
[TD="align: right"]6</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]21</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Avocado</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]52</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]32</SPAN>
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]
