How do I get information to archive onto another sheet when the expiry date is reached?
Also I am using the formula on other sheets to capture certain information on the master sheet <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <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]--><!--[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]--> =IF(ISERROR(SMALL(IF(Allocation!$D$2:$D$100="Yes",ROW($D$2:$D$100)-ROW($D$2)+1),ROWS(F$2:F18))),"",INDEX(Allocation!F$2:F$100,SMALL(IF(Allocation!$D$2:$D$100="Yes",ROW($D$2:$D$100)-ROW($D$2)+1),ROWS(F$2:F18))))
When the data is moved from the master sheet is interferes with the other sheets and they become blank?? Can anyone assist with this?
Master sheet as below;
<table border="0" cellpadding="0" cellspacing="0" width="663"><col style="width: 54pt;" width="72"> <col style="width: 109pt;" width="145"> <col style="width: 56pt;" width="75"> <col style="width: 32pt;" width="42"> <col style="width: 55pt;" width="73"> <col style="width: 48pt;" width="64"> <col style="width: 89pt;" width="118"> <col style="width: 56pt;" width="74"> <tbody><tr style="height: 57.75pt;" height="77"> <td class="xl31" style="height: 57.75pt; width: 54pt;" height="77" width="72">Date</td> <td class="xl32" style="border-left: medium none; width: 109pt;" width="145">Name</td> <td class="xl31" style="border-left: medium none; width: 56pt;" width="75">DOB</td> <td class="xl32" style="border-left: medium none; width: 32pt;" width="42">ATSI</td> <td class="xl32" style="border-left: medium none; width: 55pt;" width="73">Jaid</td> <td class="xl32" style="border-left: medium none; width: 48pt;" width="64">Order</td> <td class="xl32" style="border-left: medium none; width: 89pt;" width="118">Manager</td> <td class="xl31" style="border-left: medium none; width: 56pt;" width="74">Order Expiry</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl30" style="height: 12.75pt; border-top: medium none;" height="17">01/09/2011</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">DUCK, Daffy</td> <td class="xl29" style="border-top: medium none; border-left: medium none;">19/07/1971</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">Yes</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">11</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">CBO</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">Garry Smith</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">30/08/2013</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl30" style="height: 12.75pt; border-top: medium none;" height="17">01/09/2011</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">BROWN, Bill</td> <td class="xl29" style="border-top: medium none; border-left: medium none;">04/06/1976</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">No</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">22</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">CBO</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">Joe Miles</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">31/08/2012</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl30" style="height: 12.75pt; border-top: medium none;" height="17">01/09/2011</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">PILL, Bill</td> <td class="xl29" style="border-top: medium none; border-left: medium none;">27/05/1987</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">No</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">33</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">CBO</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">Bill Bob</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">31/09/2012</td> </tr> </tbody></table>
Also I am using the formula on other sheets to capture certain information on the master sheet <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <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]--><!--[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]--> =IF(ISERROR(SMALL(IF(Allocation!$D$2:$D$100="Yes",ROW($D$2:$D$100)-ROW($D$2)+1),ROWS(F$2:F18))),"",INDEX(Allocation!F$2:F$100,SMALL(IF(Allocation!$D$2:$D$100="Yes",ROW($D$2:$D$100)-ROW($D$2)+1),ROWS(F$2:F18))))
When the data is moved from the master sheet is interferes with the other sheets and they become blank?? Can anyone assist with this?
Master sheet as below;
<table border="0" cellpadding="0" cellspacing="0" width="663"><col style="width: 54pt;" width="72"> <col style="width: 109pt;" width="145"> <col style="width: 56pt;" width="75"> <col style="width: 32pt;" width="42"> <col style="width: 55pt;" width="73"> <col style="width: 48pt;" width="64"> <col style="width: 89pt;" width="118"> <col style="width: 56pt;" width="74"> <tbody><tr style="height: 57.75pt;" height="77"> <td class="xl31" style="height: 57.75pt; width: 54pt;" height="77" width="72">Date</td> <td class="xl32" style="border-left: medium none; width: 109pt;" width="145">Name</td> <td class="xl31" style="border-left: medium none; width: 56pt;" width="75">DOB</td> <td class="xl32" style="border-left: medium none; width: 32pt;" width="42">ATSI</td> <td class="xl32" style="border-left: medium none; width: 55pt;" width="73">Jaid</td> <td class="xl32" style="border-left: medium none; width: 48pt;" width="64">Order</td> <td class="xl32" style="border-left: medium none; width: 89pt;" width="118">Manager</td> <td class="xl31" style="border-left: medium none; width: 56pt;" width="74">Order Expiry</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl30" style="height: 12.75pt; border-top: medium none;" height="17">01/09/2011</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">DUCK, Daffy</td> <td class="xl29" style="border-top: medium none; border-left: medium none;">19/07/1971</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">Yes</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">11</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">CBO</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">Garry Smith</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">30/08/2013</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl30" style="height: 12.75pt; border-top: medium none;" height="17">01/09/2011</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">BROWN, Bill</td> <td class="xl29" style="border-top: medium none; border-left: medium none;">04/06/1976</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">No</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">22</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">CBO</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">Joe Miles</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">31/08/2012</td> </tr> <tr style="height: 12.75pt;" height="17"> <td class="xl30" style="height: 12.75pt; border-top: medium none;" height="17">01/09/2011</td> <td class="xl27" style="border-top: medium none; border-left: medium none;">PILL, Bill</td> <td class="xl29" style="border-top: medium none; border-left: medium none;">27/05/1987</td> <td class="xl26" style="border-top: medium none; border-left: medium none;">No</td> <td class="xl25" style="border-top: medium none; border-left: medium none;">33</td> <td class="xl28" style="border-top: medium none; border-left: medium none;">CBO</td> <td class="xl24" style="border-top: medium none; border-left: medium none;">Bill Bob</td> <td class="xl30" style="border-top: medium none; border-left: medium none;">31/09/2012</td> </tr> </tbody></table>