Consolidation of interview questions for different departments

**reginafilangie** · 06-05-2012, 03:51 PM

I am not sure if this is the right place to post this, but I thought I'd give it a shot. Right now I'm trying to organize interview questions that were given to about 20 different departments at work. As shown in the attachment, there are many tabs to organize the different questions, and some tabs have up to 15 questions with longer answers (that can be shortened to about 10 words at most). What would be the best way to organize this with either code or a different program or anything so that it can be shown neatly to a manager? It's also important to have this data on hand either in the form of a chart or somethin gelse.

Right now suggestions are to have each tab be a question and inside would be the answers from each department (Which seems like it would rack up a LOT of tabs). Another suggestion is to have all of the questions in the first column, and each department on the top row, and the questions filled in, which seems too cluttered because it's not numerical data.

If this is the wrong forum, please direct me to the right one. Any suggestion would be greatly appreciated!

Thank you all so much :-)

excel.PNG

**Mordred** · 06-05-2012, 04:14 PM

I have created two questionnaires and for both I put the questions and answers into one sheet and then displayed them in another sheet that I used as a sort of report sheet. Your questionnaire is a fair bit bigger than mine were so I don't know if that is the most optimal idea. I'm curious, do your questions change for each tab or are they relatively the same? If they are all similar then just aggregate them into one sheet and display them all in aggregate form. If they are different and you want to keep the outputs separate from one another. I personally would go with your second suggestion

have all of the questions in the first column, and each department on the top row, and the questions filled in

At first thought you may think it will all be cluttered I don't think it would be that bad.

My 2 pennies!

**reginafilangie** · 06-05-2012, 04:21 PM

The questions are the same for every department and there are about 50 of them. Where is your example located?

Thanks for helping!

**Mordred** · 06-05-2012, 04:28 PM

I don't have an example to show anymore as they were made 2 years ago and got tossed with many files when we converted from Office 2003 to 2007. If the questions are the same then keep the workbook layout the same with all the sheets as that would be easier for departments and their people to answer (keep it simple for them, trust me on that). Create a Summary sheet or something like that and load it with all of the answers when the questionnaire time frame (if there is one) is finished. From there you could set up a filter on the data for display purposes. If you need help with consolodating the data into one sheet, I would suggest to you that it would be in your best interest to upload a workbook to the this forum so that the good helping people here can code it correctly or apply the appropriate functions/formulas to it.