Copy data from Sheet 1 if x = yes

[SF_2011_uk]

I have a database of information, which I would like to use to populate the values in other sheets if it matches a given criteria.

My issue is, values in Sheet 1 column G can change from No to Yes. Therefore continually updating the list in Sheet 2.

If value in sheet 1, column G = Yes, I then need it to copy the associated values from columns B:C into A:B columns in sheet 2. However Sheet 2 also contains additional details that are manually entered and are not found in the Database.

I tried =FILTER but this didn't keep the manually entered information aligned with the correct record in sheet 2 when a new record as added due to a change in sheet 1, column G

Can anyone suggest a solution?

I will be using 365 desktop for this.

[AliGW]

Administrative Note:

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...her-sheet.html