I am just starting to learn VBA and thought this would be a little easier, but not making much progress. I am using Bill Jelen's 2003 VBA book as a guide.
I have multiple workbooks in the same folder. In each workbook there are several worksheets. I want to be able to open all workbooks and each worksheet, copy the same cells each time into a new workbook, thus creating one workbook with all the information from all the workbooks.
In my example excel file, I have created two worksheets. The first worksheet named OriginalWorksheet! contains the data I want to copy and then paste into the new workbook. This worksheet is the same in multiple worksheet per workbook.
Then, copy and paste special to a merged workbook (example is the worksheet NewMergeWorkbook!).