Assigning Data Range from 2 strings of text

[MatF]

Hi,
Im new to Macros. Im trying to find a string of text assign that to be the top of the data and then find a different string and assign that to be the bottom of the data.
Then run a loop whilst inside that data range. Am i going about it the right way?
Attached is a sample data file. Any help would be appreciated. I have made the parts that arent working into comments.
Thanks, Mat

Please Login or Register  to view this content.

[JBeaucaire]

Can you explain what your final result is supposed to look like, or post an "after" sheet?

[MatF]

Here is the after sheet before the sort.

The next step in the macro is to sort by column A and then delete everything else underneath.

My concern at this point is to get the data range assigned and to do the loop while inside that range.

[JBeaucaire]

Maybe like this:

Please Login or Register  to view this content.

[MatF]

Thanks JBeaucaire, Worked fantastic!