bennhrios9
New Member
- Joined
- Sep 28, 2021
- Messages
- 11
- Office Version
- 2016
- Platform
- Windows
Hello,
I need help getting data from multiple Excel files in a folder and putting it into one file. The data I need is in 4 different columns that range from B to E with rows that range from 13 to 24. Columns C, D, and E need their own worksheet in the new file and column B will be in each of these worksheets. In a each worksheet of the new file, the columns should correspond to each individual file that the data was extracted from. The output should look like the example worksheet below. Please, help. Thank you.
I need help getting data from multiple Excel files in a folder and putting it into one file. The data I need is in 4 different columns that range from B to E with rows that range from 13 to 24. Columns C, D, and E need their own worksheet in the new file and column B will be in each of these worksheets. In a each worksheet of the new file, the columns should correspond to each individual file that the data was extracted from. The output should look like the example worksheet below. Please, help. Thank you.