I have a spreadsheet with items similar to below:
<tbody>
#
item code
item description
item size
notes
cost
001
Tool Box Prepack
1UN
47.75
CONTAINS:
0001
Screwdriver
1UN
2.79
002
Ladder
1UN
87.79
</tbody>
I am trying to create a macro that will search for the word "Prepack" in...