Hello, I am working on a project in excel and I need help to automate a few steps. I am trying to build something in excel that will automatically copy different cells in one sheet and paste it in another. I am not quite sure how to do this or what I need to do. Its almost like a loop. Also, there are cells in the first sheet that say either "Yes" or "No". If Yes, then there is more information that needs copied. If no, then the program should move to the next row. To protect project confidentiality, I created a new survey with dummy data to show what I mean by this. The first sheet is the raw data from the survey, and the second sheet is what I want it to be automated to. I am not shy to vba if there is a code or a function that will do this for me that would work. Thank you all for your time and help!
