Copy the contents of a cell to another sheet only if a column in the same row is set to "Yes"
I am trying to automate copying of customer names from one sheet to another based on a second Yes/No column. Only customers with "Yes" in the secondary column will be copied to the new sheet. The secondary sheet will contain additional columns, so the Automation function will not facilitate the copy in the way I need it to since it only copies complete rows. Similarly, a Report with a filter won't work due to the new columns. Anyone have any suggestions on how to accomplish this? Thank you.
Help Article Resources
Check out the Formula Handbook template!