Hello,
I managed to get the macro shown here (https://www.exceldemy.com/excel-macro-extract-data-from-multiple-excel-files/) under 4. Extract Data from Selected Files... to work, but would like to transpose the data. The data I want to extract is located in F16:F20 in each file and I would like...