Forum Discussion
Transfer data one sheet to another
Good afternoon everyone,
I am in need of some assistance.
I have two sheets, sheet A and sheet B.
Sheet A has all the data, one column is only filled with yes or no.
Is there a way to only have the yes rows be transferred over automatically to sheet B?
I tried but I get certain lines filled but there are a lot of empty rows on sheet B in between the lines that say yes.
Thanks!!
I am in need of some assistance.
I have two sheets, sheet A and sheet B.
Sheet A has all the data, one column is only filled with yes or no.
Is there a way to only have the yes rows be transferred over automatically to sheet B?
I tried but I get certain lines filled but there are a lot of empty rows on sheet B in between the lines that say yes.
Thanks!!
5 Replies
As variant Power Query could work - query A, filter on Yes, return result to B.
Advanced Filter also could be an option.
- I’m a novice. 🙂 can you explain both options or provide me with a link(s) where I can get step by step?
You may start from this About Power Query in Excel - Excel (microsoft.com) . For step by step instructions it's better to use sample file, steps are very depend on how concrete data is organized.
