Hello,
I am trying to do a small pull of data between two worksheets but in an active manner, I'm hoping someone here might be able to figure this one out as I can't come up with a perfect solution.
Sample Data on Worksheet1:
On Worksheet2 I would like to pull anything that says 'Yes' in Worksheet1's Column A - this is using a data validation list of Yes/No
Desired results for Worksheet2:
I would like this to be dynamic so that anything switched to Yes shows up on Worksheet2 and when it switches to No, it disappears from Worksheet2. I understand that something like this could be done in Access but I would like to keep this in Excel if possible.
Thank you
I am trying to do a small pull of data between two worksheets but in an active manner, I'm hoping someone here might be able to figure this one out as I can't come up with a perfect solution.
Sample Data on Worksheet1:

On Worksheet2 I would like to pull anything that says 'Yes' in Worksheet1's Column A - this is using a data validation list of Yes/No
Desired results for Worksheet2:

I would like this to be dynamic so that anything switched to Yes shows up on Worksheet2 and when it switches to No, it disappears from Worksheet2. I understand that something like this could be done in Access but I would like to keep this in Excel if possible.
Thank you