1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Am I making a common mistake trying to pull a list from another workbook using "Filter"?

I am trying to pull names from another workbook utilizing "Filter." I am starting in workbook1. The lists is in workbook2, but some names are not needed. I am selecting the array in workbook2, then how to filter by saying adjacent data in workbook2 = criteria. For whatever reason, I am getting the typical #Value error. Any common mistake I could be making.

submitted by /u/LogicPrevail
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article