Jun 21 2022 08:49 AM - edited Jul 01 2022 08:51 AM
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. If anyone has any ideas I am all ears. Thank you!
Jun 22 2022 07:44 AM
Jun 22 2022 08:14 AM - edited Jun 22 2022 08:15 AM
It's difficult to recommend a solution without a sample workbook. I suspect you might be able to use the FILTER function to accomplish this task.
https://support.microsoft.com/en-us/office/filter-function-f4f7cb66-82eb-4767-8f7c-4877ad80c759
Jun 22 2022 08:29 AM
Hello @GabrielSzep , It is very difficult to understand the concept with out demo data, but try to use conditional IF formula with Vlookup or index match for getting data based on "YES","NO".
Thanks
Sivakumar
Jul 01 2022 08:36 AM
To not violate confidentiality, I created a Dummy Survey to show what I am trying to accomplish. Sheet0 is what generates straight from Qualtrics. Sheet1 is what I want to transform the data into. I did this manually by copying and pasting. Does anyone know how to do this automatically? Preferably by clicking a button with VBA. Thank You!