VBA按条件筛选和复制数据

I have one sheet which needs to filter based on some conditions and then copy the first column value/And Column AT to another sheet. First Sheet(Sheet1) contains multiple Rows(But we need utilize only A and AT column) so in case if AT column contains "N/A" or Blank Values..then we need to copy the column A and AT Value to Sheet2. I am writing VBA codes as below and stuck in filtering in YDest sheets where I need to filter data and put into another sheet 'Missing Info' on YdestI have one sheet which needs to filter based on