I am working with a food inventory workbook. Let's call it inventory.xls. It has worksheets named for food categories such as meat, dairy, etc.
I need a macro that will scan a new worksheet (import.xls) with food items sorted by category and write them to the appropriate sheet, starting at row 8 on the existing sheet within inventory.xls
Below is an example of both worksheets.
inventory.xls
DAIRY
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 56px"><COL style="WIDTH: 209px"><COL style="WIDTH: 73px"><COL style="WIDTH: 35px"><COL style="WIDTH: 71px"><COL style="WIDTH: 73px"><COL style="WIDTH: 81px"><COL style="WIDTH: 54px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 52px"><COL style="WIDTH: 48px"><COL style="WIDTH: 54px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>Todays Date:</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>12/20/2010</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>Total:</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>Date of Last Inventory:</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>11/30/2010</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold">$ - </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>Days Since Last Inventory:</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>20</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>Last Person to Inventory:</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-STYLE: italic; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" rowSpan=2 colSpan=3></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">SUPC</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Item Description</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Brand</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Count</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Package Size</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Mfg #</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Re-order Count</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Case Cost</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Case</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Each</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #003366; FONT-FAMILY: Calibri; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Unit Cost </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #003366; FONT-FAMILY: Calibri; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Units in Stock </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #003366; FONT-FAMILY: Calibri; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Total $ </TD></TR><TR style="HEIGHT: 21px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: ARIAL"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 8pt; FONT-WEIGHT: bold">- </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 8pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #ccccff; FONT-SIZE: 8pt; FONT-WEIGHT: bold">- </TD></TR><TR style="HEIGHT: 21px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: ARIAL; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 8pt; FONT-WEIGHT: bold">- </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 8pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 8pt; FONT-WEIGHT: bold">- </TD></TR></TBODY></TABLE>
import.xls
Sheet1
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: ARIAL,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 48px"><COL style="WIDTH: 48px"><COL style="WIDTH: 48px"><COL style="WIDTH: 48px"><COL style="WIDTH: 48px"><COL style="WIDTH: 48px"><COL style="WIDTH: 48px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>DAIRY PRODUCTS</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">8965881</TD><TD>BUTTERMILK 1% LOW FAT</TD><TD style="TEXT-ALIGN: right"> 9</TD><TD>/</TD><TD>.5 GAL</TD><TD>WHLFARM</TD><TD style="TEXT-ALIGN: right">19.95</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">6267272</TD><TD>CHEESE AMER LOAF YEL ^</TD><TD>Only</TD><TD>/</TD><TD>5 LB</TD><TD>BBRLCLS</TD><TD style="TEXT-ALIGN: right">14.99</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">6697114</TD><TD>CHEESE AMER YEL 120 SLI ^</TD><TD style="TEXT-ALIGN: right"> 4</TD><TD>/</TD><TD>5 LB</TD><TD>BBRLCLS</TD><TD style="TEXT-ALIGN: right">43.61</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">2406163</TD><TD>CHEESE CHDR SHRD YEL FCY MILD^</TD><TD>Only</TD><TD>/</TD><TD>5 LB</TD><TD>CASASOL</TD><TD style="TEXT-ALIGN: right">12.98</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right">8953028</TD><TD>CHEESE COTTAGE SMALL CURD 2% ^</TD><TD style="TEXT-ALIGN: right"> 2</TD><TD>/</TD><TD>5 LB</TD><TD>WHLFARM</TD><TD style="TEXT-ALIGN: right">24.50</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right">2006559</TD><TD>CHEESE CREAM NEUFCH 1/3 LS FAT</TD><TD>Only</TD><TD>/</TD><TD>3 LB</TD><TD>SYS IMP</TD><TD style="TEXT-ALIGN: right">6.77</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right">7234958</TD><TD>CHEESE CUBE CHDR/COJCK/PEP JCK</TD><TD style="TEXT-ALIGN: right"> 3</TD><TD>/</TD><TD>5#</TD><TD>BBRLIMP</TD><TD style="TEXT-ALIGN: right">75.25</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right">9714023</TD><TD>CHEESE PARM SHAVED</TD><TD>Only</TD><TD>/</TD><TD>5 LB</TD><TD>BELGIO</TD><TD style="TEXT-ALIGN: right">22.27</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right">8256323</TD><TD>CHEESE SWISS SLI</TD><TD style="TEXT-ALIGN: right"> 8</TD><TD>/</TD><TD>1.5 LB</TD><TD>BBRLIMP</TD><TD style="TEXT-ALIGN: right">49.11</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right">5020193</TD><TD>CREAM SOUR CULTRD GRADE A ^</TD><TD style="TEXT-ALIGN: right"> 2</TD><TD>/</TD><TD>5 LB</TD><TD>WHLFARM</TD><TD style="TEXT-ALIGN: right">20.83</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right">5321906</TD><TD>CREAM SOUR PURE GRD A SQ PACKT</TD><TD style="TEXT-ALIGN: right">100</TD><TD>/</TD><TD>1 OZ</TD><TD>DAISY</TD><TD style="TEXT-ALIGN: right">10.39</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right">0012104</TD><TD>CREAM WHIPPING HVY 40% FRSH</TD><TD style="TEXT-ALIGN: right"> 8</TD><TD>/</TD><TD>32 OZ</TD><TD>WHLFARM</TD><TD style="TEXT-ALIGN: right">31.05</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right">2105815</TD><TD>EGG SHELL MED GR AA USDA WHT</TD><TD style="TEXT-ALIGN: right"> 1</TD><TD>/</TD><TD>15 DZ</TD><TD>WHLFCLS</TD><TD style="TEXT-ALIGN: right">16.99</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right">2130060</TD><TD>ICE CREAM VAN</TD><TD style="TEXT-ALIGN: right"> 1</TD><TD>/</TD><TD>3 GAL</TD><TD>WHLFREL</TD><TD style="TEXT-ALIGN: right">17.19</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right">6631347</TD><TD>MARGARINE SOFT BUTRY SPREAD</TD><TD style="TEXT-ALIGN: right">600</TD><TD>/</TD><TD>5 GM</TD><TD>SMT BAL</TD><TD style="TEXT-ALIGN: right">27.33</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right">0417527</TD><TD>MARGARINE SOLID ALL VEG</TD><TD style="TEXT-ALIGN: right"> 30</TD><TD>/</TD><TD>1 LB</TD><TD>WHLFCLS</TD><TD style="TEXT-ALIGN: right">20.31</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: right">2389534</TD><TD>TOPPING WHPD IN BAG</TD><TD style="TEXT-ALIGN: right"> 12</TD><TD>/</TD><TD>16 OZ</TD><TD>WHLFCLS</TD><TD style="TEXT-ALIGN: right">35.31</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD>MEATS</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: right">1434729</TD><TD>BACON END & PIECES</TD><TD>Only</TD><TD>/</TD><TD>3 LB</TD><TD>FARMLND</TD><TD style="TEXT-ALIGN: right">10.60</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: right">1073402</TD><TD>BACON LAYFLAT 18/22 CT ^</TD><TD style="TEXT-ALIGN: right"> 1</TD><TD>/</TD><TD>15 LB</TD><TD>SYS REL</TD><TD style="TEXT-ALIGN: right">56.42</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: right">1070218</TD><TD>BACON SLAB SLI 18/22CT TX SMK^</TD><TD style="TEXT-ALIGN: right"> 1</TD><TD>/</TD><TD>15 LB</TD><TD>SYS REL</TD><TD style="TEXT-ALIGN: right">39.88</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: right">6632582</TD><TD>BEEF CORNED SLI</TD><TD style="TEXT-ALIGN: right"> 6</TD><TD>/</TD><TD>2 LB</TD><TD>HORMEL</TD><TD style="TEXT-ALIGN: right">66.66</TD></TR></TBODY></TABLE>
I need all of the items under the "DAIRY PRODUCTS" to write to a sheet in inventory.xls called "DAIRY" and so on with each category.
I can write a simple macro that will normalize the data into the correct columns before it is written to the new sheets.
Can anyone help me?
Dale
I need a macro that will scan a new worksheet (import.xls) with food items sorted by category and write them to the appropriate sheet, starting at row 8 on the existing sheet within inventory.xls
Below is an example of both worksheets.
inventory.xls
DAIRY
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: Arial,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 56px"><COL style="WIDTH: 209px"><COL style="WIDTH: 73px"><COL style="WIDTH: 35px"><COL style="WIDTH: 71px"><COL style="WIDTH: 73px"><COL style="WIDTH: 81px"><COL style="WIDTH: 54px"><COL style="WIDTH: 30px"><COL style="WIDTH: 30px"><COL style="WIDTH: 52px"><COL style="WIDTH: 48px"><COL style="WIDTH: 54px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD></TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD><TD>H</TD><TD>I</TD><TD>J</TD><TD>K</TD><TD>L</TD><TD>M</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">1</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>Todays Date:</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>12/20/2010</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>Total:</TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">2</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>Date of Last Inventory:</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>11/30/2010</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold">$ - </TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>Days Since Last Inventory:</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>20</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2>Last Person to Inventory:</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" colSpan=2></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-STYLE: italic; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold" rowSpan=2 colSpan=3></TD></TR><TR style="HEIGHT: 18px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 8pt"></TD></TR><TR style="HEIGHT: 41px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">SUPC</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Item Description</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Brand</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Count</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Package Size</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Mfg #</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Re-order Count</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Case Cost</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Case</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #800000; FONT-FAMILY: Calibri; COLOR: #c0c0c0; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Each</TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #003366; FONT-FAMILY: Calibri; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Unit Cost </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #003366; FONT-FAMILY: Calibri; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Units in Stock </TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #003366; FONT-FAMILY: Calibri; COLOR: #ffffff; FONT-SIZE: 9pt; FONT-WEIGHT: bold">Total $ </TD></TR><TR style="HEIGHT: 21px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: ARIAL"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="FONT-FAMILY: Calibri; FONT-SIZE: 9pt"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 8pt; FONT-WEIGHT: bold">- </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #ccccff; FONT-SIZE: 8pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #ccccff; FONT-SIZE: 8pt; FONT-WEIGHT: bold">- </TD></TR><TR style="HEIGHT: 21px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: ARIAL; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-FAMILY: Calibri; FONT-SIZE: 9pt; FONT-WEIGHT: bold"></TD><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 8pt; FONT-WEIGHT: bold">- </TD><TD style="TEXT-ALIGN: right; BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 8pt; FONT-WEIGHT: bold"></TD><TD style="BACKGROUND-COLOR: #c0c0c0; FONT-SIZE: 8pt; FONT-WEIGHT: bold">- </TD></TR></TBODY></TABLE>
import.xls
Sheet1
<TABLE style="BACKGROUND-COLOR: #ffffff; PADDING-LEFT: 2pt; PADDING-RIGHT: 2pt; FONT-FAMILY: ARIAL,Arial; FONT-SIZE: 10pt" border=1 cellSpacing=0 cellPadding=0><COLGROUP><COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 48px"><COL style="WIDTH: 48px"><COL style="WIDTH: 48px"><COL style="WIDTH: 48px"><COL style="WIDTH: 48px"><COL style="WIDTH: 48px"><COL style="WIDTH: 48px"></COLGROUP><TBODY><TR style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt; FONT-WEIGHT: bold"><TD> </TD><TD>A</TD><TD>B</TD><TD>C</TD><TD>D</TD><TD>E</TD><TD>F</TD><TD>G</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">3</TD><TD>DAIRY PRODUCTS</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">4</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">5</TD><TD style="TEXT-ALIGN: right">8965881</TD><TD>BUTTERMILK 1% LOW FAT</TD><TD style="TEXT-ALIGN: right"> 9</TD><TD>/</TD><TD>.5 GAL</TD><TD>WHLFARM</TD><TD style="TEXT-ALIGN: right">19.95</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">6</TD><TD style="TEXT-ALIGN: right">6267272</TD><TD>CHEESE AMER LOAF YEL ^</TD><TD>Only</TD><TD>/</TD><TD>5 LB</TD><TD>BBRLCLS</TD><TD style="TEXT-ALIGN: right">14.99</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">7</TD><TD style="TEXT-ALIGN: right">6697114</TD><TD>CHEESE AMER YEL 120 SLI ^</TD><TD style="TEXT-ALIGN: right"> 4</TD><TD>/</TD><TD>5 LB</TD><TD>BBRLCLS</TD><TD style="TEXT-ALIGN: right">43.61</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">8</TD><TD style="TEXT-ALIGN: right">2406163</TD><TD>CHEESE CHDR SHRD YEL FCY MILD^</TD><TD>Only</TD><TD>/</TD><TD>5 LB</TD><TD>CASASOL</TD><TD style="TEXT-ALIGN: right">12.98</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">9</TD><TD style="TEXT-ALIGN: right">8953028</TD><TD>CHEESE COTTAGE SMALL CURD 2% ^</TD><TD style="TEXT-ALIGN: right"> 2</TD><TD>/</TD><TD>5 LB</TD><TD>WHLFARM</TD><TD style="TEXT-ALIGN: right">24.50</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">10</TD><TD style="TEXT-ALIGN: right">2006559</TD><TD>CHEESE CREAM NEUFCH 1/3 LS FAT</TD><TD>Only</TD><TD>/</TD><TD>3 LB</TD><TD>SYS IMP</TD><TD style="TEXT-ALIGN: right">6.77</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">11</TD><TD style="TEXT-ALIGN: right">7234958</TD><TD>CHEESE CUBE CHDR/COJCK/PEP JCK</TD><TD style="TEXT-ALIGN: right"> 3</TD><TD>/</TD><TD>5#</TD><TD>BBRLIMP</TD><TD style="TEXT-ALIGN: right">75.25</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">12</TD><TD style="TEXT-ALIGN: right">9714023</TD><TD>CHEESE PARM SHAVED</TD><TD>Only</TD><TD>/</TD><TD>5 LB</TD><TD>BELGIO</TD><TD style="TEXT-ALIGN: right">22.27</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">13</TD><TD style="TEXT-ALIGN: right">8256323</TD><TD>CHEESE SWISS SLI</TD><TD style="TEXT-ALIGN: right"> 8</TD><TD>/</TD><TD>1.5 LB</TD><TD>BBRLIMP</TD><TD style="TEXT-ALIGN: right">49.11</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">14</TD><TD style="TEXT-ALIGN: right">5020193</TD><TD>CREAM SOUR CULTRD GRADE A ^</TD><TD style="TEXT-ALIGN: right"> 2</TD><TD>/</TD><TD>5 LB</TD><TD>WHLFARM</TD><TD style="TEXT-ALIGN: right">20.83</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">15</TD><TD style="TEXT-ALIGN: right">5321906</TD><TD>CREAM SOUR PURE GRD A SQ PACKT</TD><TD style="TEXT-ALIGN: right">100</TD><TD>/</TD><TD>1 OZ</TD><TD>DAISY</TD><TD style="TEXT-ALIGN: right">10.39</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">16</TD><TD style="TEXT-ALIGN: right">0012104</TD><TD>CREAM WHIPPING HVY 40% FRSH</TD><TD style="TEXT-ALIGN: right"> 8</TD><TD>/</TD><TD>32 OZ</TD><TD>WHLFARM</TD><TD style="TEXT-ALIGN: right">31.05</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">17</TD><TD style="TEXT-ALIGN: right">2105815</TD><TD>EGG SHELL MED GR AA USDA WHT</TD><TD style="TEXT-ALIGN: right"> 1</TD><TD>/</TD><TD>15 DZ</TD><TD>WHLFCLS</TD><TD style="TEXT-ALIGN: right">16.99</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">18</TD><TD style="TEXT-ALIGN: right">2130060</TD><TD>ICE CREAM VAN</TD><TD style="TEXT-ALIGN: right"> 1</TD><TD>/</TD><TD>3 GAL</TD><TD>WHLFREL</TD><TD style="TEXT-ALIGN: right">17.19</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">19</TD><TD style="TEXT-ALIGN: right">6631347</TD><TD>MARGARINE SOFT BUTRY SPREAD</TD><TD style="TEXT-ALIGN: right">600</TD><TD>/</TD><TD>5 GM</TD><TD>SMT BAL</TD><TD style="TEXT-ALIGN: right">27.33</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">20</TD><TD style="TEXT-ALIGN: right">0417527</TD><TD>MARGARINE SOLID ALL VEG</TD><TD style="TEXT-ALIGN: right"> 30</TD><TD>/</TD><TD>1 LB</TD><TD>WHLFCLS</TD><TD style="TEXT-ALIGN: right">20.31</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">21</TD><TD style="TEXT-ALIGN: right">2389534</TD><TD>TOPPING WHPD IN BAG</TD><TD style="TEXT-ALIGN: right"> 12</TD><TD>/</TD><TD>16 OZ</TD><TD>WHLFCLS</TD><TD style="TEXT-ALIGN: right">35.31</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">22</TD><TD>MEATS</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">23</TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">24</TD><TD style="TEXT-ALIGN: right">1434729</TD><TD>BACON END & PIECES</TD><TD>Only</TD><TD>/</TD><TD>3 LB</TD><TD>FARMLND</TD><TD style="TEXT-ALIGN: right">10.60</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">25</TD><TD style="TEXT-ALIGN: right">1073402</TD><TD>BACON LAYFLAT 18/22 CT ^</TD><TD style="TEXT-ALIGN: right"> 1</TD><TD>/</TD><TD>15 LB</TD><TD>SYS REL</TD><TD style="TEXT-ALIGN: right">56.42</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">26</TD><TD style="TEXT-ALIGN: right">1070218</TD><TD>BACON SLAB SLI 18/22CT TX SMK^</TD><TD style="TEXT-ALIGN: right"> 1</TD><TD>/</TD><TD>15 LB</TD><TD>SYS REL</TD><TD style="TEXT-ALIGN: right">39.88</TD></TR><TR style="HEIGHT: 17px"><TD style="TEXT-ALIGN: center; BACKGROUND-COLOR: #cacaca; FONT-SIZE: 8pt">27</TD><TD style="TEXT-ALIGN: right">6632582</TD><TD>BEEF CORNED SLI</TD><TD style="TEXT-ALIGN: right"> 6</TD><TD>/</TD><TD>2 LB</TD><TD>HORMEL</TD><TD style="TEXT-ALIGN: right">66.66</TD></TR></TBODY></TABLE>
I need all of the items under the "DAIRY PRODUCTS" to write to a sheet in inventory.xls called "DAIRY" and so on with each category.
I can write a simple macro that will normalize the data into the correct columns before it is written to the new sheets.
Can anyone help me?
Dale
