Extracting specific worksheets out of multiple workbooks
I have a bunch of different workbooks saved in a folder. All of the worksheets in in every workbook are formatted and named the same in all the workbooks. What I need is to extract a specific worksheet from all the workbooks and combine them in into one workbook renaming the individual worksheets the first 10 characters from the cell A1. I want to close the workbook I extracted the worksheet from without savingsaving
Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.