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.

How can I make it with a Macro?

Thanks in advance.

Bye!

Andrea

 

[SkipVought]

Hi,

Are the workbooks in the same folder?

Are the workbooks already open?

What sheets in each workbook?

What row on each sheet?

Have you tried using your macro recorder?

Please answer ALL questions completely.

Skip,

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

 

[Nukles]

Thank you very much SkipVought!

Are the workbooks in the same folder?
Yes they will be in the same folder

Are the workbooks already open?
No they will be around 300 so I would like to find a way not open them all...

What sheets in each workbook?
There is a spreadsheet named "Support Worksheet"

What row on each sheet?
Row 2 for exporting to a first collection, row 5 for a second collection of rows

Have you tried using your macro recorder?
Yes but I don't know how to make it general...

Thanks for your help!

Andrea

 

[PHV]

What is your actual (recorded) code and where are you stuck ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

...in addition to posting your actual recorded code, please explain,

"Row 2 for exporting to a first collection, row 5 for a second collection of rows"

Where are the first colection and second collection?





Skip,

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