Home » Forums » Open Source Learning Center » Question and Answer

HOW TO EXTRACT SOME ROWS FROM ANOTHER XLS FILE

Submitted by DAI on 27 February, 2013 - 11:20

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

‹ combination between column and line chars Multiline visible text in Cell ›
»
Almir's picture

I would use MS Query from within Excel

Submitted by Almir on 27 February, 2013 - 21:18.

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.

»