Transfer data one sheet to another

%3CLINGO-SUB%20id%3D%22lingo-sub-2261763%22%20slang%3D%22en-US%22%3ETransfer%20data%20one%20sheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2261763%22%20slang%3D%22en-US%22%3EGood%20afternoon%20everyone%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20in%20need%20of%20some%20assistance.%3CBR%20%2F%3EI%20have%20two%20sheets%2C%20sheet%20A%20and%20sheet%20B.%3CBR%20%2F%3ESheet%20A%20has%20all%20the%20data%2C%20one%20column%20is%20only%20filled%20with%20yes%20or%20no.%3CBR%20%2F%3E%3CBR%20%2F%3EIs%20there%20a%20way%20to%20only%20have%20the%20yes%20rows%20be%20transferred%20over%20automatically%20to%20sheet%20B%3F%3CBR%20%2F%3EI%20tried%20but%20I%20get%20certain%20lines%20filled%20but%20there%20are%20a%20lot%20of%20empty%20rows%20on%20sheet%20B%20in%20between%20the%20lines%20that%20say%20yes.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks!!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2261763%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2261792%22%20slang%3D%22en-US%22%3ERe%3A%20Transfer%20data%20one%20sheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2261792%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1020866%22%20target%3D%22_blank%22%3E%40Rnieto%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAs%20variant%20Power%20Query%20could%20work%20-%20query%20A%2C%20filter%20on%20Yes%2C%20return%20result%20to%20B.%3C%2FP%3E%0A%3CP%3EAdvanced%20Filter%20also%20could%20be%20an%20option.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2261903%22%20slang%3D%22en-US%22%3ERe%3A%20Transfer%20data%20one%20sheet%20to%20another%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2261903%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20a%20novice.%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20can%20you%20explain%20both%20options%20or%20provide%20me%20with%20a%20link(s)%20where%20I%20can%20get%20step%20by%20step%3F%3C%2FLINGO-BODY%3E
New Contributor
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!!
5 Replies

@Rnieto 

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?

@Rnieto 

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.

Thanks!!
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?

@Rnieto 

Sorry, I don't know. It's better to start separate conversation with this question.