Below is part of the worksheet in question. The numbers at the top are the values I need to keep. They are in column a, row 1. What follows is the sales report. After all the header gibberish is the sales info. To the far left under item # is the info that is in column a (i.e. "71 Cookie", "81 Cereal w/ milk", etc.) Thus, the item number and name are in the same column. When I run the macro using the code you provided nothing happens. Not sure what I'm doing wrong.
12173, 12168, 12167, 12165, 12164, 12158, 12153, 11708, 11707, 11706, 11705, 11704, 11703, 11702, 11701, 11498, 11360, 11328, 11327, 11323, 11322, 11314, 11313, 11307, 11302, 11301, 11178, 11172, 11166, 10726, 10725, 10724, 10723, 10716, 10715, 10714, 10713, 10711, 10710, 3045, 3044, 2975, 2972, 2516, 2515, 2514
<html
<body BGCOLOR=ffffee
<pre
<font face="Courier,New" s ize=1
-------------------------- ------- --------- --------------------- ----------- --- --- --- ---------------------------------------------------
Menu Item Sales <iUnivers ity of Ka nsas</i 1028 Briles
The Studio All <font color=0000ff SEP20'13 4:52PM</font
-------------------------- ------- --------- --------------------- ----------- --- --- --- ---------------------------------------------------
Examine <font color=0000f fSEP19'13 2:00 00A M - SEP20'13 2:00AM</font
Item # Item Name #Sold Net Sales %of Sales
--------- ---------------- ------ --------- -------------------- ----------
71 Cookie 2 1.8 0.03%
81 Cereal w/ Milk 1 2.45 0.04%
93 12oz Water 1 0.99 0.02%
1102 Med Fountain 27 42.93 0.72%
1103 Lg Fountain 5 9.45 0.16%
1105 0.25 Water 8 2 0.03%
1206 Rck Chlk LatteSm 2 7 0.12%
1209 Rck Chlk LatteMd 3 12.6 0.21%
1216 Frappe 8 32 0.53%
1218 MdShot intheDark 1 3.5 0.06%
1220 Sm Roasterie 2 3.4 0.06%
1221 Md Roasterie 6 12 0.20%
1222 Lg Roasterie 1 2.1 0.04%
1228 SmPulseHC 2 5.6 0.09%
1229 MdPulseHC 4 13 0.22%
1237 ADD Large 6 2.7 0.05%
1243 Hot Tea 6 10.5 0.18%
1257 White Mocha Sm 1 3.5 0.06%
1258 White Mocha Md 1 4.2 0.07%
1267 Iced Latte 2 7.2 0.12%
1269 Iced Chai 3 10.5 0.18%
1272 Cold Press Coffe 1 2 0.03%
1278 Iced White Mocha 1 4.2 0.07%
1279 Iced CarmamelMac 2 8.4 0.14%
1297 Mexican Coke 31 31 0.52%
1299 Gold Peak Tea 1 2.2 0.04%
1314 PA Strwbry Lemon 1 2.2 0.04%
1329 12oz Cherry Zero 2 1.8 0.03%
1343 Vita Wtr XXX 1 2.2 0.04%
1346 V8 Spl Tropical 2 4.2 0.07%
1360 NOS Grape 1 2.5 0.04%
1364 GP Tea Swt Green 1 2.2 0.04%
1367 GP Tea Sweetened 5 11 0.18%
1379 WATER 16 0 0.00%
1395 12oz Fanta Grape 1 0.9 0.02%
1399 Coke 12 Pack 3 5.97 0.10%