I want to filter and copy rows from one workbook to another. I already
have the code to do it from one spread sheet to another. I wanted to
see if I could modify just this one line of code:


Set ws1 = Sheets("Solution Direct Tracking")

To be able to choose a worksheet in another workbook that isn't open.
Is this possible or do I need to copy that worksheet to the new
workbook filter/sort and then delete it again? If so could someone
point me in the right direction to be able to create that code.


Thanks


Kris