I want to bring data from one spreadsheet to another, if a field is 'No', then pull comments from D5 over to another sheet.
So one sheet - D5 is 'Yes' or 'No' - if 'No' and D6 are comments. I would like the data to appear on another sheet.
If 'Sheet1' - D5 = 'No' then pull data from 'Sheet1' - D2. Thanks Experts.