Sign up ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am a 6th year medical student and I'm working on my thesis. I have no experience with programming whatsoever, a friend recommended me to post my question here. I am strugling with the following problem:

I have data of 400 patients, stored in 400 different excel files. Each file contains 34 columns in a specific order, let's say A to Z. The order is the same in each of these 400 files.

Now I need to a make a new excel document that contains the first column of each patient. So I need all the first columns of my 400 different excel files, lined up next to each other in a new document. Preferebally in the form of a automatic script.

After that I want to do the exact same thing but for the second column, then the third and so on.

This is probably a problem that has already been solved. Otherwise could someone help me out?

You have my thanks!

share|improve this question

1 Answer 1

Here someone has created a macro to put the contents of all open workbooks into one:

It could also be a good idea to import those into an Access or SQL database, especially since you have matching columns.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.