I need to use VBA code to get data from a closed workbook that is on a network folder, I only need the data that meets certain criteria.
ClosedFilePath = P:\FolderA\SubfolderA\Correos\
ClosedFileName = Registro_Correos_OficialesX.xlsm
ClosedFileSheet = Registros
ClosedFileRange = (A2 : L?) " this range is a table named Table1
CurrentFileName = Correos_Pendientes.xlsm
CurrentSheetName = "Pendientes"
So, I need to get all the data where Column(G) = "Administracion" and Column(K) = "Pendiente"
Thank you so much guys, attached is the source file and hope you guya can help me!