rdbmerge.png

<div>
as i see it, the biggest issue is &quot;(IS DIFFERENT IN EACH WORKBOOK) &nbsp;&quot;<br />
<br />
how do you or user manually chose which worksheet to extract ? &nbsp;there must be some methodology behind the selection.
</div>


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.

<div>
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.<br />
<br />
I have recommended this question be closed as follows:<br />
<br />
Accept: ProfessorJimJam (<a href="https:#a41861767" rel="ugc">https:#a41861767</a>)<br />
<br />
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.<br />
<br />
frankhelk<br />
Experts-Exchange Cleanup Volunteer
</div>


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 [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

<div>
<div class="content wysiwyg-content">
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) &nbsp;and then consolidate into a single worksheet.<br />
<br />
starting at row 2 and ending with the last worksheet
</div>
</div>


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

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

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.