Merge data from all workbooks in folder.

**marcosis** · 07-18-2019, 10:23 AM

Hey,

I need a Macro that will search for the term "ORI" in a particular sheet, lets say Sheet1 as an example. It will then copy the row that that cell appears on and paste it on a new master sheet.
It will do this for all the workbooks in a particular folder and paste them under each other on one sheet on the master.

Hope that makes sense.

Ive used similar macros in the past, that asks you to specify a particular folder and it extracts all of the information from each sheet in one go, but i wanted to only copy the lines where a cell contains "ORI"

Any help would be much appreciated.

Thank you!

Marc

**CK76** · 07-18-2019, 10:29 AM

You have Excel 2016. Rather than using VBA code, I'd recommend use of Get & Transform (PowerQuery).

Use Get Data -> From File -> From Folder. It will give you dialog menu to combine workbooks in a folder.

Once all data are appended to single table using the menu, you can then filter for "ORI" before loading it back to worksheet.

Have a read of links.
https://support.office.com/en-us/art...8-6a00041c90e4
http://excelunplugged.com/2018/02/13...i-bulletproof/

Merge data from all workbooks in folder.

LinkBack

Thread Tools

Rate This Thread

Display

Merge data from all workbooks in folder.

Re: Merge data from all workbooks in folder.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Merge multiple workbooks stored in a folder

Merge 3 workbooks from a folder into one workbook

VBA to merge workbooks in a folder

Merge data from all workbooks in folder based on first 3 characters of filename

Merge multiple workbooks & move each merged worksheet into another folder

[SOLVED] Merge a range from all workbooks in a folder to one Master Sheet

Merge workbooks in a folder and rename sheets to previous filenames

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions