I have an active sheet(Sheet2) with the extracted data and a command button, which when clicked should copy the data into another workbook with some conditions applied.
For ex- Source file SRC.xlsm has 5 columns and in the 2nd column I need to check for the condition: If the value there is 'TRUE', only then the specific row should get copied to destination. Otherwise not. The Destination workbook DEST.xls(Sheet1) should get saved and closed automatically. Could somebody help me out with the code please?
For ex- Source file SRC.xlsm has 5 columns and in the 2nd column I need to check for the condition: If the value there is 'TRUE', only then the specific row should get copied to destination. Otherwise not. The Destination workbook DEST.xls(Sheet1) should get saved and closed automatically. Could somebody help me out with the code please?
