VBA code to Loop through a folder and subfolders and stack together all the data in a sheet called "SeedPrep"

[jskasango]

VBA code to Loop through a folder and subfolders and stack together all the data in a sheet called "SeedPrep" starting from row 25 and reserving the headers from row 1 of the first found sheet.
The code should skip any file that is not a *.xl*. TIA.

 

[rlv01]

There is a good code example in this thread.

vba-loop through subfolders

How to loop through folders and their sub folders in vba. I tried using this code but its not working for me. my folder variable gets the correct name i.e. "d:\neha" but my variable sf for subfolder is not working Sub ShowFolderList() Dim fso, folder, f1, sf Set fso =...

www.mrexcel.com

 

[jskasango]

I have looked at the thread. It does not help much because it is about listing and not stacking the sheets found. Also, I wish to have the code let me browse to the desired parent folder instead of me having to indicate parent folder in the code. Thanks all the same.

 

[jskasango]

What I need is Using Excel 2016, please write me a VBA code that will let me select a parent folder, loop through the parent folder and sub folders, look for all workbooks *.XL* entire row copy and stack all sheets named "Seedprep" with data starting from row 25. Pick column headers from row 1 of the first sheet. Name the new workbook "ParentFolder_Consolidated".

 

[rlv01]

please write me a VBA code

I'm sorry, but I do not have the time to devote to that at the moment. Perhaps someone else will see your post and become interested. I wish you well.