Good Morning Mike and Tony,

I am trying to accomplish something similar to Tony and am
unfortunately just learning Excel VBA.

What I have a is a rawdata sheet (sheet1) with hundreds of lines of
data. What I'd like to do is based on a specific "securityname" from
sheet1 populate sheet2 with the rows specific to that "securityname"
until that securityname is no longer found on sheet1.

Is this possible with the code snippet you provided Tony this
morning? Any assistance offered is greatly appreciated. Thank you
both in advance.