Import multiple rows from different Excel into one Excel worksheet

[Nukles]

Hello!

I have multiple Excel files with similar names, and there is one row in which I am interested in them. I would like to combine all their rows into one single Excel sheet, one row after the other in multiple rows.

Is it possible to make it with the software itself or do I need to download another software?

Bye!

Andrea

 

[SkipVought]

Hi,

There is no Excel feature that can do that.

It can, however, be done with VBA code, if you are up to programming.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Nukles]

Thanks for your answer!

Could someone explain how to write a macro for it? is it something easy? (I guess so, for the few Java programming I know...)

Thanks!!!

 

[SkipVought]

For VBA help, please post your questions in Forum707.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}