• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Advanced Filter VBA

S

Shivank

New Member
Hi,

I have a macro which is filtering data using a said criteria (advanced filter). I would like to use the the data range from a closed workbook. is that possible? If yes, could you please help me out? really struggling with this.

My code:

"
Sub Filterme()
Sheet3.Range("D4").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheet2.Range("BC2:BK3"), CopyToRange:=Sheet2.Range("C10:AM10"), Unique:=False
End Sub
/"

best,
 
++
The macro is in the workbook -> workbook1.xlsx

and the raw data is lying in c:/shivank/workbook2.xlsx
[sheet1. A1:X15]


Shivank said:
Hi,

I have a macro which is filtering data using a said criteria (advanced filter). I would like to use the the data range from a closed workbook. is that possible? If yes, could you please help me out? really struggling with this.

My code:

"
Sub Filterme()
Sheet3.Range("D4").CurrentRegion.AdvancedFilter Action:=xlFilterCopy, _
CriteriaRange:=Sheet2.Range("BC2:BK3"), CopyToRange:=Sheet2.Range("C10:AM10"), Unique:=False
End Sub
/"

best,
Click to expand...
 
You must log in or register to reply here.
Back
Top