Help with complex filtering in my existing VBA

  • Hello - have a real big head scratcher trying to streamline a process. I am looking for a way to filter data in another sheet based off of a criteria in another sheet. explanation below:


    my file and data is huge so going to keep it simple below. so lets just say below is sheet A. in another workbook i have only the Unique values in common with sheet A, and that workbook B i need to filter down to what my criteria is in sheet A, for example workbook B will have (123.234.456.555.666) in it. so part of the code would be to filter down that workbook based off of the criteria filter in sheet A. I attached my existing code - it looks like a lot but it really just formats and exports a file. any help is appreciated I am struggling.


    TypeUniqueCriteria for filter
    AA123AA
    AA234BB
    AA456
    BB555
    CC666