¿como puedo filtar datos de varios libros de excel a una hoja?

%3CLINGO-SUB%20id%3D%22lingo-sub-1921855%22%20slang%3D%22es-ES%22%3EHow%20do%20I%20filter%20data%20from%20multiple%20excel%20workbooks%20to%20a%20sheet%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1921855%22%20slang%3D%22es-ES%22%3E%3CP%3EHello!%20I%20have%20a%20lot%20of%20books%20with%20data%20that%20I'd%20like%20to%20extract%20%22easy%22%20from%20a%20single%20book.%3C%2FP%3E%3CP%3Eit's%20more%20than%20a%20thousand%20excel%20books.%20how%20could%20I%20do%20that%3F%20will%20there%20be%20any%20formula%20or%20way%20to%20extract%20that%20information%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20thank%20you%20very%20much%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1921855%22%20slang%3D%22es-ES%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hola! tengo muchos libros con datos que quisiera extraer de forma "fácil" a un único libro.

son mas de mil libros de excel. como podría hacer eso ? habrá alguna formula o manera de extraer esa información ?

 

Les agradezco mucho 

0 Replies