• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Merging Excel data

Texan

New Member
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
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
 

Texan

New Member
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
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_Into_One.html
 
Top