I need to copy some information from one Workbook to another one, both Workbooks are in a network on diferent folders, let say:
On the Sheet "Registros" of the Registro_Correos_Oficiales.xlsm', a have a table named Table1, this table has 13 colums, (A to M)
So, the value I need to find is "Administration" that in on column H, then once I find this value, I need to bring all the information in the NewFile.
I try this formula:
But ovious is wrong, I hope you guys can help me, thank you in advance.