How could I copy multiple sheets to another workbook using VBA.
The condition is Cells(I,4) is nonblank. My input file is named "Mergefile" and my ouput file is named "Detail OD". The ouput data will be in sheets("Data").
And I want to copy range B to range J if condition is met. My example file is below, I just want to copy nonblank data and ignore the filtered row.
