I work in music and event production taking care of booking artists/sound engineers/etc. for events that I have listed in a main events sheet. I also have a separate sheet specifically for those people I'm booking. There is a column in the main sheet that is headed 'Sound Engineer' in which I input yes or no. I then copy and paste that row into the sound engineer sheet sorted by the events date. I would like to automate this process with a function if its possible!
Thank you for any help provided in advance.
LK