Copy and Paste range into separate worksheet

[Schaefer156]

Hello,
I am looking to figure out this VBA code I am trying to write for a project I am working on, I have it that it will search for a certain text in column L, once it finds that certain word I want it to copy and paste columns A-K down from the row that it found the certain word until a blank cell and only copy those row, for example, I have the code search for K3 and when it finds it it will copy rows 6-11 to the next worksheet. And I know I can do it by setting the range but if someone comes in and adds a row it will mess up the range.

 

[mumps]

You are very welcome.

 

[Schaefer156]

You are very welcome.

Hello Mumps, sorry to bother, the code works great but I only am having one issue with it when I get to a section that I would not like in the list I noticed it copied all the way down to K3.4 and so on when there is a gap in between K3.4 and K3.5 it will copy all the way down to K3.5, is there a possible fix for this I'm new to VBA so I'm not great at it.

 

[mumps]

I guess the fastest and easiest way to solve the problem without having to change the macro, would be to insert a character such as a hyphen in the blank cell to the right of "Date". If that's not possible, please let me know.

 

[Schaefer156]

Yup, that worked I get how that works now Thankyou again!

 

[mumps]

My pleasure.