Excel Help with CriteriaRange in VBA .AdvancedFilter Method
. Hi senior ?Colleagues?!, . . One way I am learning my Excel / VBA is by answering Threads here. . I answered one with both a Formula and a VBA Code. The code was much too complicated As I was not yet familiar enough with the method I expect is the best, the VBA Advanced Filter Method. Particularly I do not have the experience yet in getting the correct CriteriaRange . can someone help? . So, a simplified example.. I start with this. Using Excel 2007 - 1 2 3 4 5 6 7 8 JL DataAdvFilt ????? . And wot I finally want is this. Using Excel 2007 - 1 2 3
This question generated 15 answers. To proceed to the answers, click here.