Solved

Consolidate specific worksheets residing in multiple workbooks in folder into one single worksheet

Posted on 2016-10-26
3
25 Views
Last Modified: 2016-11-27
I have a folder named (BAKING), which has about 30 workbooks. Each workbook has 4 worksheets, out of these worksheets I'd like to extract one worksheet (IS DIFFERENT IN EACH WORKBOOK)  and then consolidate into a single worksheet.

starting at row 2 and ending with the last worksheet
0
Comment
Question by:MATO0618
3 Comments
 
LVL 25

Accepted Solution

by:
ProfessorJimJam earned 500 total points
ID: 41861767
the easiest and best solution to achieve what you described is using free Add-in from my friend, Ron de Bruin

http://www.rondebruin.nl/win/addins/rdbmerge.htm

rdbmerge.png
1
 
LVL 32

Expert Comment

by:Robberbaron (robr)
ID: 41864882
as i see it, the biggest issue is "(IS DIFFERENT IN EACH WORKBOOK)  "

how do you or user manually chose which worksheet to extract ?  there must be some methodology behind the selection.
0
 
LVL 13

Expert Comment

by:frankhelk
ID: 41902941
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I have recommended this question be closed as follows:

Accept: ProfessorJimJam (https:#a41861767)

If you feel this question should be closed differently, post an objection and the moderators will review all objections and close it as they feel fit. If no one objects, this question will be closed automatically the way described above.

frankhelk
Experts-Exchange Cleanup Volunteer
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

This is an Add-On procedure to be used in conjunction with the code provided in Reducing EE Email Clutter using Outlook (http://www.experts-exchange.com/Software/Office_Productivity/Groupware/Outlook/A_3146-Outlook-Processing-EE-emails-on-Receive.…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now