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

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
What did you already try? – Hennes Dec 13 '15 at 20:24

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.