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:
![Sample-Data.jpg](/board/proxy.php?image=https%3A%2F%2Fi.postimg.cc%2F44cCTXTg%2FSample-Data.jpg&hash=f342a56179365ccb18ecb3cb2c9b8ffd)
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:
![Sample-Data2.png](/board/proxy.php?image=https%3A%2F%2Fi.postimg.cc%2FBvPp1QpZ%2FSample-Data2.png&hash=c678242c3d1cd5433d1f96afacca1eae)
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