Hello,

I need to copy all of the cells that match criteria that are in a drop down. The drop down gives me a corresponding number which is in cell D1 on Sheet2. I then need all of the corresponding rows that have the corresponding number in row A that is in Cell D1, copied into Sheet2 below the drop down. I think I need to use the IF Then function and loop it, but I haven't been able to get it to work. Please see attached. Thanks.