Hello,

I need to copy over the data from column A in Worksheet 'Key Issue Details', to column C in Worksheet 'Calendar & Exam Summary'. The number of cells populated in 'Key Issue Details' changes with a refresh at opening (it is synced to a list in SharePoint). There is a condition for whether the data should be copied to 'Calendar & Exam Summary', which is noted below. I am unsure of how to copy the different cells meeting the criteria over to 'Caledar & Exam Summary' in sequential order down column C.

Condition Applied:
1. 'Key Issue Details' cell C2 must equal data in another worksheet cell 'PickList' A20

Formula Used:
=IFERROR(IF(FIND(PickList!$A$20,'Key Issue Details'!$C2)<>0,'Key Issue Details'!$A2,""),"")

This formula is working great if cell A2 'Key Issue Details' meets the criteria, but only checks one cell for data. Is there code that will pull over all data into the column that meets the condition?

Thank you!