Is this possible?

[MatthewM]

I have Excel 2003 and I want to take data from one page of a worksheet to another using a certain parameter. It would be something like this

Column A________ Column B ______Column C
Equipment __________P.M.________ Hours

Now I want the search parameter to be anything over 250 hours in Column C. So if Column C is over 250 hours I want the whole row to be moved to this other page.

Also, is there anyway to re-arrange the data once it gets over to the other page. There are more columns on the source page than I want on the new one. And I want to change the order of the data coming over. If not that's ok, even getting it over to another page would save me hours of tedium.

I know I could just get some other software and it would make it way easier, but I just work here and dont make those kinds of decisions, although I have suggested that. Any help would be appreciated.

Matt

 

[MatthewM]

<b>Excel 2003</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">3</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">LE/LR#</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">DESCRIPTION</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">LOCATION</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">PM HOURS</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">PM TO BE PERFORMED</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">HRS AFTER PM</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">DATE PERFORMED</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">COMMENTS</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1118</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Sakai 84" Padfoot Roller</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2498</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">226</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">James Moye</td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1125</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Isuzu 20KW Generator</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2498</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">233</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">James Moye</td></tr><tr ><td style="color: #161120;text-align: center;">7</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1152</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Cat CP433E Padfoot Compactor</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2580</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">225</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Malcolm Bailey</td></tr><tr ><td style="color: #161120;text-align: center;">8</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;">1155</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;">1993 WhiteGMC Water Truck</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;">2580</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;">207</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;">1</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #C0C0C0;;">Malcolm Bailey</td></tr><tr ><td style="color: #161120;text-align: center;">9</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1157</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">M&L 20KW Generator</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2560</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">234</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">4</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Jose Trujillo</td></tr><tr ><td style="color: #161120;text-align: center;">10</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1167</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">John Deere CT332 Crawler Skid Steer</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2498</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">308</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">James Moye</td></tr><tr ><td style="color: #161120;text-align: center;">11</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1171</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Cat 279C Crawler Skid Steer</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2634</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">313</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">1</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Gonzalo Cardenas</td></tr><tr ><td style="color: #161120;text-align: center;">12</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2060</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Case 480F LL Loader/Broom</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2580</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">223</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">3</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Malcolm Bailey</td></tr><tr ><td style="color: #161120;text-align: center;">13</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2061</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Cat 279C Crawler Skid Steer</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2634</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">290</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;"></td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Gonzalo Cardenas</td></tr></tbody></table><p style="width:17.4em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">WEEKLY MAINTENANCE WORK ORDER</p><br /><br />

 

[MatthewM]

Columns A, B, C, H, and I, need to move to the Weekly Maintenance Work Order if the number in column H is over 250.

An additional question. Is there a way to make Column I print the name of the foreman on that Job. For instance if Location 2498 was Jose Gomez, could I somehow make another sheet and tie that number into his name so that everytime I type in 2498, his name fills in a different column?

 

[Yahya]

Hi Mattew
this is your original sheet
<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: center;border-top: 1px solid black;background-color: #FFFF00;;">1118</td><td style="border-top: 1px solid black;background-color: #FFFF00;;">84" Sakai Padfoot Roller (2004)</td><td style="text-align: center;border-top: 1px solid black;background-color: #FFFF00;;">3</td><td style="text-align: center;border-top: 1px solid black;background-color: #FFFF00;;">9/28/10</td><td style="text-align: center;border-top: 1px solid black;background-color: #FFFF00;;">3078</td><td style="text-align: center;border-top: 1px solid black;background-color: #FFFF00;;">3312</td><td style="text-align: center;border-top: 1px solid black;background-color: #FFFF00;;">8/29/11</td><td style="text-align: center;border-top: 1px solid black;background-color: #FFFF00;;">234</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;background-color: #FFFF00;;">2498</td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: center;background-color: #FFFFFF;;">1119</td><td style="background-color: #FFFFFF;;">Hyundai HL740-7E Wheel Loader (2004)</td><td style="text-align: center;background-color: #FFFFFF;;">3</td><td style="text-align: center;background-color: #FFFFFF;;">07/05/2011</td><td style="text-align: center;background-color: #FFFFFF;;">4458</td><td style="text-align: center;background-color: #FFFFFF;;">4561</td><td style="text-align: center;background-color: #FFFFFF;;">8/29/11</td><td style="text-align: center;background-color: #FFFFFF;;">103</td><td style="text-align: center;border-right: 1px solid black;background-color: #FFFFFF;;">2498</td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: center;background-color: #FFFFFF;;">1121</td><td style="background-color: #FFFFFF;;">25KW Ingersall Rand Generator (2005)</td><td style="text-align: center;background-color: #FFFFFF;;">4</td><td style="text-align: center;background-color: #FFFFFF;;">11/10/2010</td><td style="text-align: center;background-color: #FFFFFF;;">8411</td><td style="text-align: center;background-color: #FFFFFF;;">9296</td><td style="text-align: center;background-color: #FFFFFF;;">01/10/2011</td><td style="text-align: center;background-color: #FFFFFF;;">885</td><td style="text-align: center;border-right: 1px solid black;background-color: #FFFFFF;;">SHOP</td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: center;background-color: #FFFFFF;;">1122</td><td style="background-color: #FFFFFF;;">2005 Ford F650 Mechanics Truck</td><td style="text-align: center;background-color: #FFFFFF;;">1</td><td style="text-align: center;background-color: #FFFFFF;;">04/06/2010</td><td style="text-align: center;background-color: #FFFFFF;;">121879</td><td style="text-align: center;background-color: #FFFFFF;;">121879</td><td style="text-align: center;background-color: #FFFFFF;;">04/06/2010</td><td style="text-align: center;background-color: #FFFFFF;;">0</td><td style="text-align: center;border-right: 1px solid black;background-color: #FFFFFF;;">CARL</td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: center;background-color: #FFFFFF;;">1123</td><td style="background-color: #FFFFFF;;">6" Gorman-Rupp Water Pump</td><td style="text-align: center;background-color: #FFFFFF;;">4</td><td style="text-align: center;background-color: #FFFFFF;;">03/02/2011</td><td style="text-align: center;background-color: #FFFFFF;;">804</td><td style="text-align: center;background-color: #FFFFFF;;">804</td><td style="text-align: center;background-color: #FFFFFF;;">03/02/2011</td><td style="text-align: center;background-color: #FFFFFF;;">0</td><td style="text-align: center;border-right: 1px solid black;background-color: #FFFFFF;;">2619</td></tr><tr ><td style="color: #161120;text-align: center;">31</td><td style="text-align: center;background-color: #FFFF00;;">1125</td><td style="background-color: #FFFF00;;">20KW Isuzu Generator</td><td style="text-align: center;background-color: #FFFF00;;">4</td><td style="text-align: center;background-color: #FFFF00;;">7/28/11</td><td style="text-align: center;background-color: #FFFF00;;">744</td><td style="text-align: center;background-color: #FFFF00;;">1299</td><td style="text-align: center;background-color: #FFFF00;;">8/29/11</td><td style="text-align: center;background-color: #FFFF00;;">555</td><td style="text-align: center;border-right: 1px solid black;background-color: #FFFF00;;">2498</td></tr><tr ><td style="color: #161120;text-align: center;">32</td><td style="text-align: center;background-color: #FFFFFF;;">1129</td><td style="background-color: #FFFFFF;;">1998 GMC Water Truck</td><td style="text-align: center;background-color: #FFFFFF;;">4</td><td style="text-align: center;background-color: #FFFFFF;;">10/20/08</td><td style="text-align: center;background-color: #FFFFFF;;">123005</td><td style="text-align: center;background-color: #FFFFFF;;">125388</td><td style="text-align: center;background-color: #FFFFFF;;">8/29/11</td><td style="text-align: center;background-color: #FFFFFF;;">2383</td><td style="text-align: center;border-right: 1px solid black;background-color: #FFFFFF;;">2498</td></tr><tr ><td style="color: #161120;text-align: center;">33</td><td style="text-align: center;background-color: #FFFFFF;;">1130</td><td style="background-color: #FFFFFF;;">6" Gorman-Rupp Pump</td><td style="text-align: center;background-color: #FFFFFF;;">4</td><td style="text-align: center;background-color: #FFFFFF;;">08/04/2010</td><td style="text-align: center;background-color: #FFFFFF;;">4920</td><td style="text-align: center;background-color: #FFFFFF;;">5135</td><td style="text-align: center;background-color: #FFFFFF;;">7/28/11</td><td style="text-align: center;background-color: #FFFFFF;;">215</td><td style="text-align: center;border-right: 1px solid black;background-color: #FFFFFF;;">2560</td></tr><tr ><td style="color: #161120;text-align: center;">34</td><td style="text-align: center;border-bottom: 1px solid black;background-color: #FFFFFF;;">1134</td><td style="border-bottom: 1px solid black;background-color: #FFFFFF;;">Mitsubishi FG25N-LP 5000# Forklift</td><td style="text-align: center;border-bottom: 1px solid black;background-color: #FFFFFF;;">1</td><td style="text-align: center;border-bottom: 1px solid black;background-color: #FFFFFF;;"></td><td style="text-align: center;border-bottom: 1px solid black;background-color: #FFFFFF;;">6</td><td style="text-align: center;border-bottom: 1px solid black;background-color: #FFFFFF;;">124</td><td style="text-align: center;border-bottom: 1px solid black;background-color: #FFFFFF;;">5/21/07</td><td style="text-align: center;border-bottom: 1px solid black;background-color: #FFFFFF;;">6</td><td style="text-align: center;border-right: 1px solid black;border-bottom: 1px solid black;background-color: #FFFFFF;;">SHOP</td></tr></tbody></table><p style="width:8.4em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">OWNEDEQUIPMENT</p><br /><br />

and this is the result

<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /><col /><col /><col /><col /><col /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th><th>C</th><th>D</th><th>E</th><th>F</th><th>G</th><th>H</th><th>I</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td><td style="text-align: right;border-bottom: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">LE/LR#</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">LE/LR#</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">DESCRIPTION</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">LOCATION</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">PM HOURS</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">PM TO BE PERFORMED</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">HRS AFTER PM</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">DATE PERFORMED</td><td style="font-weight: bold;text-align: center;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;background-color: #FFFFFF;;">COMMENTS</td></tr><tr ><td style="color: #161120;text-align: center;">4</td><td style="text-align: right;border-top: 1px solid black;;">1118</td><td style="border-top: 1px solid black;;">84" Sakai Padfoot Roller (2004)</td><td style="text-align: right;border-top: 1px solid black;;">2498</td><td style="text-align: right;border-top: 1px solid black;;">3</td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td><td style="text-align: right;border-top: 1px solid black;;"></td></tr><tr ><td style="color: #161120;text-align: center;">5</td><td style="text-align: right;;">1119</td><td style=";">Hyundai HL740-7E Wheel Loader (2004)</td><td style="text-align: right;;">2498</td><td style="text-align: right;;">3</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: #161120;text-align: center;">6</td><td style="text-align: right;;">1121</td><td style=";">25KW Ingersall Rand Generator (2005)</td><td style=";">SHOP</td><td style="text-align: right;;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr></tbody></table><p style="width:17.4em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">WEEKLY MAINTENANCE WORK ORDER</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A1</th><td style="text-align:left">=COUNTIF(<font color="Blue">OWNEDEQUIPMENT!H26:H34,">=250"</font>)</td></tr></tbody></table></td></tr></table><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Array Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A4</th><td style="text-align:left">{=IF(<font color="Blue">ROWS(<font color="Red">$A$4:A4</font>)<=$A$1,INDEX(<font color="Red">OWNEDEQUIPMENT!$A$26:$A$34,SMALL(<font color="Green">IF(<font color="Purple">OWNEDEQUIPMENT!$H$26:$H$34>=$A$1,ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26:$A$34</font>)-ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26</font>)+1</font>),ROWS(<font color="Purple">$A$4:A4</font>)</font>)</font>),""</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B4</th><td style="text-align:left">{=IF(<font color="Blue">ROWS(<font color="Red">$A$4:A4</font>)<=$A$1,INDEX(<font color="Red">OWNEDEQUIPMENT!$B$26:$B$34,SMALL(<font color="Green">IF(<font color="Purple">OWNEDEQUIPMENT!$H$26:$H$34>=$A$1,ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26:$A$34</font>)-ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26</font>)+1</font>),ROWS(<font color="Purple">$A$4:A4</font>)</font>)</font>),""</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C4</th><td style="text-align:left">{=IF(<font color="Blue">ROWS(<font color="Red">$A$4:A4</font>)<=$A$1,INDEX(<font color="Red">OWNEDEQUIPMENT!$I$26:$I$34,SMALL(<font color="Green">IF(<font color="Purple">OWNEDEQUIPMENT!$H$26:$H$34>=$A$1,ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26:$A$34</font>)-ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26</font>)+1</font>),ROWS(<font color="Purple">$A$4:A4</font>)</font>)</font>),""</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D4</th><td style="text-align:left">{=IF(<font color="Blue">ROWS(<font color="Red">$A$4:A4</font>)<=$A$1,INDEX(<font color="Red">OWNEDEQUIPMENT!$C$26:$C$34,SMALL(<font color="Green">IF(<font color="Purple">OWNEDEQUIPMENT!$H$26:$H$34>=$A$1,ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26:$A$34</font>)-ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26</font>)+1</font>),ROWS(<font color="Purple">$A$4:A4</font>)</font>)</font>),""</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A5</th><td style="text-align:left">{=IF(<font color="Blue">ROWS(<font color="Red">$A$4:A5</font>)<=$A$1,INDEX(<font color="Red">OWNEDEQUIPMENT!$A$26:$A$34,SMALL(<font color="Green">IF(<font color="Purple">OWNEDEQUIPMENT!$H$26:$H$34>=$A$1,ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26:$A$34</font>)-ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26</font>)+1</font>),ROWS(<font color="Purple">$A$4:A5</font>)</font>)</font>),""</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B5</th><td style="text-align:left">{=IF(<font color="Blue">ROWS(<font color="Red">$A$4:A5</font>)<=$A$1,INDEX(<font color="Red">OWNEDEQUIPMENT!$B$26:$B$34,SMALL(<font color="Green">IF(<font color="Purple">OWNEDEQUIPMENT!$H$26:$H$34>=$A$1,ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26:$A$34</font>)-ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26</font>)+1</font>),ROWS(<font color="Purple">$A$4:A5</font>)</font>)</font>),""</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C5</th><td style="text-align:left">{=IF(<font color="Blue">ROWS(<font color="Red">$A$4:A5</font>)<=$A$1,INDEX(<font color="Red">OWNEDEQUIPMENT!$I$26:$I$34,SMALL(<font color="Green">IF(<font color="Purple">OWNEDEQUIPMENT!$H$26:$H$34>=$A$1,ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26:$A$34</font>)-ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26</font>)+1</font>),ROWS(<font color="Purple">$A$4:A5</font>)</font>)</font>),""</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D5</th><td style="text-align:left">{=IF(<font color="Blue">ROWS(<font color="Red">$A$4:A5</font>)<=$A$1,INDEX(<font color="Red">OWNEDEQUIPMENT!$C$26:$C$34,SMALL(<font color="Green">IF(<font color="Purple">OWNEDEQUIPMENT!$H$26:$H$34>=$A$1,ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26:$A$34</font>)-ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26</font>)+1</font>),ROWS(<font color="Purple">$A$4:A5</font>)</font>)</font>),""</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">A6</th><td style="text-align:left">{=IF(<font color="Blue">ROWS(<font color="Red">$A$4:A6</font>)<=$A$1,INDEX(<font color="Red">OWNEDEQUIPMENT!$A$26:$A$34,SMALL(<font color="Green">IF(<font color="Purple">OWNEDEQUIPMENT!$H$26:$H$34>=$A$1,ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26:$A$34</font>)-ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26</font>)+1</font>),ROWS(<font color="Purple">$A$4:A6</font>)</font>)</font>),""</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">B6</th><td style="text-align:left">{=IF(<font color="Blue">ROWS(<font color="Red">$A$4:A6</font>)<=$A$1,INDEX(<font color="Red">OWNEDEQUIPMENT!$B$26:$B$34,SMALL(<font color="Green">IF(<font color="Purple">OWNEDEQUIPMENT!$H$26:$H$34>=$A$1,ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26:$A$34</font>)-ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26</font>)+1</font>),ROWS(<font color="Purple">$A$4:A6</font>)</font>)</font>),""</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">C6</th><td style="text-align:left">{=IF(<font color="Blue">ROWS(<font color="Red">$A$4:A6</font>)<=$A$1,INDEX(<font color="Red">OWNEDEQUIPMENT!$I$26:$I$34,SMALL(<font color="Green">IF(<font color="Purple">OWNEDEQUIPMENT!$H$26:$H$34>=$A$1,ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26:$A$34</font>)-ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26</font>)+1</font>),ROWS(<font color="Purple">$A$4:A6</font>)</font>)</font>),""</font>)}</td></tr><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">D6</th><td style="text-align:left">{=IF(<font color="Blue">ROWS(<font color="Red">$A$4:A6</font>)<=$A$1,INDEX(<font color="Red">OWNEDEQUIPMENT!$C$26:$C$34,SMALL(<font color="Green">IF(<font color="Purple">OWNEDEQUIPMENT!$H$26:$H$34>=$A$1,ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26:$A$34</font>)-ROW(<font color="Teal">OWNEDEQUIPMENT!$A$26</font>)+1</font>),ROWS(<font color="Purple">$A$4:A6</font>)</font>)</font>),""</font>)}</td></tr></tbody></table><b>Entered with Ctrl+Shift+Enter.</b> If entered correctly, Excel will surround with curly braces {}.
<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />

HTH

 

[Yahya]

An additional question. Is there a way to make Column I print the name of the foreman on that Job. For instance if Location 2498 was Jose Gomez, could I somehow make another sheet and tie that number into his name so that everytime I type in 2498, his name fills in a different column?

Yes Mathew you can
but Before you need to build small table
<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>A</th><th>B</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">1</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Code</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Name</td></tr><tr ><td style="color: #161120;text-align: center;">2</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2498</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Jose Gomez</td></tr><tr ><td style="color: #161120;text-align: center;">3</td><td style="text-align: right;border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">2619</td><td style="border-top: 1px solid black;border-right: 1px solid black;border-bottom: 1px solid black;border-left: 1px solid black;;">Mick</td></tr></tbody></table><p style="width:4.2em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">ForeMan</p><br /><br />

and then use it like this
<b>Excel 2007</b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px solid;border-collapse: collapse; border-color: #A6AAB6"><colgroup><col width="25px" style="background-color: #E0E0F0" /><col /><col /></colgroup><thead><tr style=" background-color: #E0E0F0;text-align: center;color: #161120"><th></th><th>I</th><th>J</th></tr></thead><tbody><tr ><td style="color: #161120;text-align: center;">25</td><td style="border-bottom: 1px solid black;;">Code</td><td style=";">FormanName</td></tr><tr ><td style="color: #161120;text-align: center;">26</td><td style="text-align: center;border-top: 1px solid black;border-right: 1px solid black;background-color: #FFFF00;;">2498</td><td style="border-left: 1px solid black;;">Jose Gomez</td></tr><tr ><td style="color: #161120;text-align: center;">27</td><td style="text-align: center;border-right: 1px solid black;background-color: #FFFFFF;;">2498</td><td style="border-left: 1px solid black;;">Jose Gomez</td></tr><tr ><td style="color: #161120;text-align: center;">28</td><td style="text-align: center;border-right: 1px solid black;background-color: #FFFFFF;;">2619</td><td style="border-left: 1px solid black;;">Mick</td></tr><tr ><td style="color: #161120;text-align: center;">29</td><td style="text-align: center;border-right: 1px solid black;background-color: #FFFF00;;">2498</td><td style="border-left: 1px solid black;;">Jose Gomez</td></tr><tr ><td style="color: #161120;text-align: center;">30</td><td style="text-align: center;border-right: 1px solid black;background-color: #FFFFFF;;">2498</td><td style="border-left: 1px solid black;;">Jose Gomez</td></tr></tbody></table><p style="width:8.4em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid #A6AAB6;border-top:none;text-align: center;background-color: #E0E0F0;color: #161120">OWNEDEQUIPMENT</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: #FFFFFF" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: #FFFFFF;border-collapse: collapse; border-color: #A6AAB6"><thead><tr style=" background-color: #E0E0F0;color: #161120"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: #E0E0F0;color: #161120">J26</th><td style="text-align:left">=VLOOKUP(<font color="Blue">I26,ForeMan!$A$1:$B$3,2,0</font>)</td></tr></tbody></table></td></tr></table><br />