I share a workbook with my band memebers via email , each member then fills in a list of songs that they want to learn to play.
I then have to consilidate the list together so that I can rank the songs , so we have a learning schedule.
the tedious part of the task is copying the lists from each member into a central sheet.
any ideas on how to automate this would great