Macro to collect survey responses into single sheet

[Jubinell]

Hi,

I have created a survey template and have people respond by typing into designated cells in their copy of the survey. All surveys are single-sheet, but they may span several pages.

I have stored the survey files that I received back in the same folder. Is there a macro that will help me do the following:

1) Combine the sheets of all files within this folder into a new excel file.
2) Go through each sheet, copy the survey answers that are stored at designated cells into a new worksheet in the following format:

QA | QB | QC | QD ...
A1 | A1 | A1 | A1
A2 | A2 | A2 | A2

where A1 is Person 1's answers to questions QA, QB, QC, QD, etc.

Anything that you have previously made that might be similar to/part of this process?

Thank you in advance

 

[hiker95]

Jubinell,

Can we have some screenshots of your Summary workbook (with before and after worksheets), and some of the completed Survey worksheets?

Please post a screenshot of your sheet(s), what you have and what you expect to achieve, with Excel Jeanie HTML 4 (contains graphic instructions).
http://www.excel-jeanie-html.de/html/hlp_schnell_en.php

Or, you can upload your workbook to www.box.net and provide us with a link to your workbook.