Disregard this, I realized it is it is impossible as I am working with
two different instances of excel application, let alone workbooks and
sheets

Went the easy way and just copied to the data to a location and then
filtered it then deleted the copied data.