Recent content by Frank

Thank you! This works a treat! F :)

Hello, Thanks a bunch. This does partially address my problem. I have some 200+ files with the data stored in F16:F20 and yes, having this transposed like this works. The files are not in alphabetic order though. Furthermore, what is missing are the file names. Ideally, I would like all file...

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