HOW TO EXTRACT SOME ROWS FROM ANOTHER XLS FILE

Hi Everybody,

I have an xls file which I consider it as a database (called A), I would like
to extract some lines from the database A, for instance, in A I have data for
12 months, and I would like to extract all the line for March to another
file, and no change for the column,

Would it be possible to do by VBA? Could you help me to do that please?
Thanks a lot for your help
DAI

Almir's picture

I would use MS Query from within Excel

I would connect to A file from another file through MS Query. If you need additional help, send me a file and I will help you.