jcarlosbernardes
New Member
- Joined
- Jul 23, 2010
- Messages
- 1
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cjb%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:595.3pt 841.9pt; margin:70.85pt 3.0cm 70.85pt 3.0cm; mso-header-margin:35.4pt; mso-footer-margin:35.4pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Hi,
<o> </o>
i'm trying to workout this problem:<o></o>
<o> </o>
I have a workbook that contains data from several workbooks. Each original workbook have data from a particulary month, and every month i have to agregate data from the last 3 month. <o></o>
<o> </o>
Like this, the July report has to have data from June and May. In August, from June and July etc etc. <o></o>
<o> </o>
How can i automate this, just to avoid editing links and formulas every month? <o></o>
<o> </o>
Thanks
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cjb%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 3.0cm 70.85pt 3.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Data from July Workbook
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cjb%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 3.0cm 70.85pt 3.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 489pt; border-collapse: collapse; margin-left: 4.8pt; margin-right: 4.8pt;" width="652" align="left" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 15pt;"> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 3.5pt; background: silver none repeat scroll 0% 0%; width: 108pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; background: silver none repeat scroll 0% 0%; width: 89pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: black black -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; background: silver none repeat scroll 0% 0%; width: 108pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; background: silver none repeat scroll 0% 0%; width: 89pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; background: silver none repeat scroll 0% 0%; width: 95pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: solid solid none; border-color: black black -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> João de Deus<o></o>
</td> <td style="border-style: solid solid none none; border-color: black black -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: black windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: black windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: black windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> ISMAI<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Modivas Sul<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Estádio do Dragão<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Campanhã<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Póvoa de Varzim<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Espaço Natureza<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> D. João II<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Matosinhos Sul<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Fórum<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none none solid solid; border-color: -moz-use-text-color -moz-use-text-color black black; border-width: medium medium 1pt 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; border-width: medium medium 1pt; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> </tbody></table>
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cjb%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 3.0cm 70.85pt 3.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Data from June Workbook
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cjb%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 3.0cm 70.85pt 3.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 489pt; margin-left: 2.75pt; border-collapse: collapse;" width="652" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 15pt;"> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 3.5pt; background: silver none repeat scroll 0% 0%; width: 108pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; background: silver none repeat scroll 0% 0%; width: 89pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; background: silver none repeat scroll 0% 0%; width: 108pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; background: silver none repeat scroll 0% 0%; width: 89pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: windowtext windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; background: silver none repeat scroll 0% 0%; width: 95pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: solid solid none; border-color: black black -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> João de Deus<o></o>
</td> <td style="border-style: solid solid none none; border-color: black black -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: black windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: black windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: solid solid none none; border-color: black windowtext -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> ISMAI<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Modivas Sul<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Estádio do Dragão<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Campanhã<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Póvoa de Varzim<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Espaço Natureza<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> D. João II<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid; border-color: -moz-use-text-color black; border-width: medium 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Matosinhos Sul<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid none none; border-color: -moz-use-text-color windowtext -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none solid solid; border-color: -moz-use-text-color black black; border-width: medium 1pt 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> Fórum<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> <tr style="height: 15pt;"> <td style="border-style: none none solid solid; border-color: -moz-use-text-color -moz-use-text-color black black; border-width: medium medium 1pt 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none none solid; border-color: -moz-use-text-color -moz-use-text-color black; border-width: medium medium 1pt; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid solid; border-color: -moz-use-text-color windowtext windowtext; border-width: medium 1pt 1pt; padding: 0cm 3.5pt; width: 108pt; height: 15pt;" width="144" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom"> </td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color windowtext windowtext -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 95pt; height: 15pt;" width="127" nowrap="nowrap" valign="bottom"> </td> </tr> </tbody></table>
<o> </o>
i'm trying to workout this problem:<o></o>
<o> </o>
I have a workbook that contains data from several workbooks. Each original workbook have data from a particulary month, and every month i have to agregate data from the last 3 month. <o></o>
<o> </o>
Like this, the July report has to have data from June and May. In August, from June and July etc etc. <o></o>
<o> </o>
How can i automate this, just to avoid editing links and formulas every month? <o></o>
<o> </o>
Thanks
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cjb%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 3.0cm 70.85pt 3.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Data from July Workbook
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cjb%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 3.0cm 70.85pt 3.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 489pt; border-collapse: collapse; margin-left: 4.8pt; margin-right: 4.8pt;" width="652" align="left" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 15pt;"> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 3.5pt; background: silver none repeat scroll 0% 0%; width: 108pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15pt;" width="144" nowrap="nowrap" valign="bottom">
Local<o></o>
Machine <o></o>
July<o></o>
June<o></o>
May<o></o>
</td> <td style="border-style: solid solid none none; border-color: black black -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBPQR3<o></o>
9.057,98<o></o>
9.057,98<o></o>
3.818,98<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBISM2<o></o>
7.974,83<o></o>
7.974,83<o></o>
5.512,48<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBMOS1<o></o>
5.787,57<o></o>
5.787,57<o></o>
2.089,03<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBEDG7<o></o>
5.774,70<o></o>
5.774,70<o></o>
5.232,00<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBCMP2<o></o>
5.745,70<o></o>
5.745,70<o></o>
2.571,40<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBPVZ2<o></o>
5.631,93<o></o>
5.631,93<o></o>
6.188,20<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBMNO2<o></o>
5.536,53<o></o>
5.536,53<o></o>
781,03<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBDJS4<o></o>
4.628,75<o></o>
4.628,75<o></o>
5.326,62<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBMTS1<o></o>
4.582,22<o></o>
4.582,22<o></o>
454,48<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBFOR1<o></o>
4.477,60<o></o>
4.477,60<o></o>
7.660,87<o></o>
Total<o></o>
<o></o>
59.197,82<o></o>
59.197,82<o></o>
39.635,10<o></o>
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cjb%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 3.0cm 70.85pt 3.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> Data from June Workbook
****** http-equiv="Content-Type" content="text/html; charset=utf-8">****** name="ProgId" content="Word.Document">****** name="Generator" content="Microsoft Word 11">****** name="Originator" content="Microsoft Word 11"><link rel="File-List" href="file:///C:%5CDOCUME%7E1%5Cjb%5CLOCALS%7E1%5CTemp%5Cmsohtml1%5C01%5Cclip_filelist.xml"><!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:HyphenationZone>21</w:HyphenationZone> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent> <w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText> <w:Compatibility> <w:BreakWrappedTables/> <w:SnapToGridInCell/> <w:WrapTextWithPunct/> <w:UseAsianBreakRules/> <w:DontGrowAutofit/> </w:Compatibility> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--><!--[if gte mso 9]><xml> <w:LatentStyles DefLockedState="false" LatentStyleCount="156"> </w:LatentStyles> </xml><![endif]--><style> <!-- /* Font Definitions */ @font-face {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:-1610611985 1073750139 0 0 159 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0cm; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} @page Section1 {size:612.0pt 792.0pt; margin:70.85pt 3.0cm 70.85pt 3.0cm; mso-header-margin:36.0pt; mso-footer-margin:36.0pt; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style><!--[if gte mso 10]> <style> /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman"; mso-ansi-language:#0400; mso-fareast-language:#0400; mso-bidi-language:#0400;} </style> <![endif]--> <table class="MsoNormalTable" style="width: 489pt; margin-left: 2.75pt; border-collapse: collapse;" width="652" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 15pt;"> <td style="border-style: solid solid none; border-color: windowtext windowtext -moz-use-text-color; border-width: 1pt 1pt medium; padding: 0cm 3.5pt; background: silver none repeat scroll 0% 0%; width: 108pt; -moz-background-clip: border; -moz-background-origin: padding; -moz-background-inline-policy: continuous; height: 15pt;" width="144" nowrap="nowrap" valign="bottom">
Local<o></o>
Machine<o></o>
June<o></o>
May<o></o>
April<o></o>
</td> <td style="border-style: solid solid none none; border-color: black black -moz-use-text-color -moz-use-text-color; border-width: 1pt 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBPQR3<o></o>
9.057,98<o></o>
3.818,98<o></o>
2.184,10<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBISM2<o></o>
7.974,83<o></o>
5.512,48<o></o>
1.925,27<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBMOS1<o></o>
5.787,57<o></o>
2.089,03<o></o>
2.463,15<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBEDG7<o></o>
5.774,70<o></o>
5.232,00<o></o>
774,73<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBCMP2<o></o>
5.745,70<o></o>
2.571,40<o></o>
1.080,13<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBPVZ2<o></o>
5.631,93<o></o>
6.188,20<o></o>
3.639,58<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBMNO2<o></o>
5.536,53<o></o>
781,03<o></o>
1.973,18<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBDJS4<o></o>
4.628,75<o></o>
5.326,62<o></o>
2.215,30<o></o>
</td> <td style="border-style: none solid none none; border-color: -moz-use-text-color black -moz-use-text-color -moz-use-text-color; border-width: medium 1pt medium medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBMTS1<o></o>
4.582,22<o></o>
454,48<o></o>
1.434,83<o></o>
</td> <td style="border-style: none solid solid none; border-color: -moz-use-text-color black black -moz-use-text-color; border-width: medium 1pt 1pt medium; padding: 0cm 3.5pt; width: 89pt; height: 15pt;" width="119" nowrap="nowrap" valign="bottom">
MVBFOR1<o></o>
4.477,60<o></o>
7.660,87<o></o>
4.972,95<o></o>
Total<o></o>
<o></o>
59.197,82<o></o>
39.635,10<o></o>
22.663,23<o></o>