Consolidating multiple workbooks

[Guest]

Good day everyone

I have reviewed the local Excel help to see what consolidate and merge are about. After further review, I don't have any idea which will accomplish what I am need to do.

I send out several worksheets that have the same questions in the same cells (column b) and users select from a validation list in column c for those questions. Then, I copy/paste all of the repsonse into one master worksheet and perform the functions I need to from there (averages, % of times answered yes for question #2, etc.). Is there a different way to get all of that data into one file and have each person's answers become a new column? If this counts, I know about zero for macro code, but am willing to try something out

Thank you in advance and have a great day

Peter

 

[Ron de Bruin]

Hi Peter

Try this
http://www.rondebruin.nl/copy3.htm

Post back if you need help


--
Regards Ron de Bruin
http://www.rondebruin.nl

Good day everyone.

I have reviewed the local Excel help to see what consolidate and merge are about. After further review, I don't have any idea

which will accomplish what I am need to do.

I send out several worksheets that have the same questions in the same cells (column b) and users select from a validation list in

column c for those questions. Then, I copy/paste all of the repsonse into one master worksheet and perform the functions I need to
from there (averages, % of times answered yes for question #2, etc.). Is there a different way to get all of that data into one
file and have each person's answers become a new column? If this counts, I know about zero for macro code, but am willing to try
something out.