-how to use VBA to search strings and return values or cells nearby

So, think your hot stuff.

Im needing to search through the attached document which is truck logs at a mine and use vba to search through the list for each of the different shovels eg SHVL1, SHVL2 & SHVL3, and when the code finds that string, to display the tonnage 2 colums back from it. Im about half way there a i think but am having trouble with strings, if it was numbers i could do it no problem

I have the idea in my head but need a genius to help me with the fine print

Heres what i have so far (that doesn't work) but it gives an idea of what i want

Please Login or Register  to view this content.

Hopefully someone konws what to do here..or has done it before
Thanks
Dan

Yes but we meant revise your original post... given you went to the effort of re-posting with tags I edited your first post.

Please be sure to read the Rules - they are for everyone's benefit to ensure things run as smoothly as possible. Often, VBA within tags is much easier to follow / analyse ...

Yes, I've PM'd antoka05 and asked them to reload... I appear to have removed the original (my bad)