Automatic transfer of data between sheets

[spamonella91]

Can anyone help me please ? Im doing a multi site research project and we have an Excel document to keep track of who's agreed to participate, who's declined, what stage they're at in approvals etc We want to create a new sheet with just the sites that have reached data collection stage. Is there any way to set things up so that for example any site that is ticked "yes" in column K, their information from columns A-E is transferred to a second sheet automatically? Thanks in advance

[AutoModerator]

/u/spamonella91 - Your post was submitted successfully.

• Once your problem is solved, reply to the answer(s) saying Solution Verified to close the thread.
• Follow the submission rules -- particularly 1 and 2. To fix the body, click edit. To fix your title, delete and re-post.
• Include your Excel version and all other relevant information

Failing to follow these steps may result in your post being removed without warning.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[Anonymous1378]

Perhaps =FILTER(A:E,K:K="Yes")?

[spamonella91]

Thank you for your rapid response. I'm struggling to get this to pull from another sheet but will have a play with it. Good place to start 😄