Chrismx222
New Member
- Joined
- Apr 18, 2008
- Messages
- 14
I have a sheet of 15,000 rows. Each row contains a different sku number.
When I'm done editing/deleting the whole sheet I only want to show certain sku numbers.
The following example is of the sheet UN edited:
<table style="border-collapse: collapse; width: 167pt;" width="222" border="0" cellpadding="0" cellspacing="0"><col style="width: 167pt;" width="222"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt; width: 167pt;" width="222" height="20">5011-AB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-AB-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-AC-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-AC-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-DAB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-DAB-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-DAC-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-DAC-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-DB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-DB-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-RB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-RB-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-RC-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-RC-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-VG-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-VG-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-AB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-AB-MED-FST</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-AC-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-AC-MED-FST</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-DAB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-DAB-MED-FST</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-DAC-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-DAC-MED-FST</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-DB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-DB-MED-SMG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-RB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-RB-MED-SMG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-RC-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-RC-MED-FST</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-VG-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-VG-MED-CSG</td> </tr> </tbody></table>
When done I want it to look like this:
<table style="border-collapse: collapse; width: 167pt;" width="222" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 15pt;" height="20"></tr><tr style="height: 15pt;" height="20"><td class="xl67" style="height: 15pt; width: 167pt;" width="222" height="20">5011-AB-MED-CLR</td></tr><tr style="height: 15pt;" height="20"><td class="xl67" style="height: 15pt;" height="20">5011-AB-MED-CSG</td></tr></tbody> </table> <table style="border-collapse: collapse; width: 167pt;" width="222" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height: 15pt;" height="20"><td class="xl67" style="height: 15pt;" height="20">5012-AB-MED-CLR</td></tr><tr style="height: 15pt;" height="20"><td class="xl67" style="height: 15pt;" height="20">5012-AB-MED-FST
</td></tr></tbody> </table>As you can see I only want to keep the 'AB' items, but some of the 'AB' items have different beginning sku numbers and some have different proceeding sku numbers. I would greatly appreciate help with this as I'm deleting the rows in between the 'AB's but this is taking a lot of time. Maybe some sort of Macro, of which I'm not sure how to write. Thank you again.
When I'm done editing/deleting the whole sheet I only want to show certain sku numbers.
The following example is of the sheet UN edited:
<table style="border-collapse: collapse; width: 167pt;" width="222" border="0" cellpadding="0" cellspacing="0"><col style="width: 167pt;" width="222"> <tbody><tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt; width: 167pt;" width="222" height="20">5011-AB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-AB-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-AC-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-AC-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-DAB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-DAB-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-DAC-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-DAC-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-DB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-DB-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-RB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-RB-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-RC-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-RC-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-VG-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5011-VG-MED-CSG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-AB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-AB-MED-FST</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-AC-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-AC-MED-FST</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-DAB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-DAB-MED-FST</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-DAC-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-DAC-MED-FST</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-DB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-DB-MED-SMG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-RB-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-RB-MED-SMG</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-RC-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-RC-MED-FST</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-VG-MED-CLR</td> </tr> <tr style="height: 15pt;" height="20"> <td class="xl67" style="height: 15pt;" height="20">5012-VG-MED-CSG</td> </tr> </tbody></table>
When done I want it to look like this:
<table style="border-collapse: collapse; width: 167pt;" width="222" border="0" cellpadding="0" cellspacing="0"> <tbody><tr style="height: 15pt;" height="20"></tr><tr style="height: 15pt;" height="20"><td class="xl67" style="height: 15pt; width: 167pt;" width="222" height="20">5011-AB-MED-CLR</td></tr><tr style="height: 15pt;" height="20"><td class="xl67" style="height: 15pt;" height="20">5011-AB-MED-CSG</td></tr></tbody> </table> <table style="border-collapse: collapse; width: 167pt;" width="222" border="0" cellpadding="0" cellspacing="0"><tbody><tr style="height: 15pt;" height="20"><td class="xl67" style="height: 15pt;" height="20">5012-AB-MED-CLR</td></tr><tr style="height: 15pt;" height="20"><td class="xl67" style="height: 15pt;" height="20">5012-AB-MED-FST
</td></tr></tbody> </table>As you can see I only want to keep the 'AB' items, but some of the 'AB' items have different beginning sku numbers and some have different proceeding sku numbers. I would greatly appreciate help with this as I'm deleting the rows in between the 'AB's but this is taking a lot of time. Maybe some sort of Macro, of which I'm not sure how to write. Thank you again.