T Texan New Member Mar 12, 2010 #1 Hi, Want to use excel for staff to rate themselves. Each staff receives s/sheet, complete and mail back. How can I get the final rating score of each member (with their details) to one spreadsheet? Trust this is not a stupid (I am not good in excel)..
Hi, Want to use excel for staff to rate themselves. Each staff receives s/sheet, complete and mail back. How can I get the final rating score of each member (with their details) to one spreadsheet? Trust this is not a stupid (I am not good in excel)..
oldchippy Active Member Mar 12, 2010 #2 Hi Texan, Take a look at Chandoo's link on consolidating to one sheet http://chandoo.org/wp/2009/02/04/satisfaction-surveys-excel/ or maybe this one from Ron de Bruin's website http://www.rondebruin.nl/linksum.htm
Hi Texan, Take a look at Chandoo's link on consolidating to one sheet http://chandoo.org/wp/2009/02/04/satisfaction-surveys-excel/ or maybe this one from Ron de Bruin's website http://www.rondebruin.nl/linksum.htm
T Texan New Member Mar 12, 2010 #3 I have followed Chandoo's and Ron De Bruin tips and it works - did 5 sheets. Thanks alot "oldchippy". Will however welcome any suggestion of automating this task when doing 300+..
I have followed Chandoo's and Ron De Bruin tips and it works - did 5 sheets. Thanks alot "oldchippy". Will however welcome any suggestion of automating this task when doing 300+..
oldchippy Active Member Mar 12, 2010 #4 Hi Texan, Can't say I've done this myself, but maybe this link will help? http://excel.tips.net/Pages/T003005_Condensing_Multiple_Worksheets_Intne.html
Hi Texan, Can't say I've done this myself, but maybe this link will help? http://excel.tips.net/Pages/T003005_Condensing_Multiple_Worksheets_Intne.html
ne.html