Solved

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

Posted on 2016-10-26
3
35 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 14

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

778 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