Hi there,
I need help with this macro. Attached is a sample Book showing a small number of rows and columns with content in Sheet1, my actual files might contain at least a few hundred rows and a variable number of columns.
What I need, is code that: 1)Finds cells containing "(LK)" in Column C (will always be this column), regardless of any other content in the cell, then, 2)Any rows meeting that criteria, I need them cut and pasted to a new Sheet(2), starting in row A2, so the headers from row 1 on the original sheet are copied and pasted with these new columns, then 3)The contents of this new sheet are sorted A-Z by Column C.
The content on the second sheet of my attached sample file show what I'm looking to achieve.
Thanks for any help!
NOTE: The name of the sheet I'll be working with will always be different so it cannot be referred to as "Sheet1" within the code. Guess 'Active Sheet' does the trick?
David
Bookmarks