Forum Discussion
Rnieto
Apr 08, 2021Copper Contributor
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 hav...
SergeiBaklan
Apr 08, 2021Diamond Contributor
As variant Power Query could work - query A, filter on Yes, return result to B.
Advanced Filter also could be an option.
Rnieto
Apr 08, 2021Copper Contributor
I’m a novice. 🙂 can you explain both options or provide me with a link(s) where I can get step by step?
- SergeiBaklanApr 08, 2021Diamond Contributor
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.
- RnietoApr 09, 2021Copper ContributorThanks!!
Another question. I’m trying to use the activex buttons while the sheet is protected but it doesn’t work. Any way to use the buttons while the sheet is protected?- SergeiBaklanApr 10, 2021Diamond Contributor
Sorry, I don't know. It's better to start separate conversation with this question.