How to copy an entire cell to another worksheet based on a cell value

%3CLINGO-SUB%20id%3D%22lingo-sub-2225891%22%20slang%3D%22en-US%22%3EHow%20to%20copy%20an%20entire%20cell%20to%20another%20worksheet%20based%20on%20a%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2225891%22%20slang%3D%22en-US%22%3E%3CP%3EHo%20to%20copy%20an%20entire%20cell%20to%20another%20worksheet%20based%20on%20a%20cell%20value%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2225891%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2229302%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20copy%20an%20entire%20cell%20to%20another%20worksheet%20based%20on%20a%20cell%20value%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2229302%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F999835%22%20target%3D%22_blank%22%3E%40ravikumarnv60%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThere%20are%20many%20lookup%20functions%20(%3CSTRONG%3EVlookup%2C%20Index%2FMatch%2C%20XLookup)%3C%2FSTRONG%3E%20in%20excel%20that%20can%20be%20used%20to%20copy%20or%20retrieve%20data%20from%20other%20worksheets%20or%20workbooks.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20may%20also%20refer%20to%20the%20below%20learning%20material%20available%20at%20Microsoft%20Product%20Support%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20title%3D%22Microsoft%20Product%20Support%22%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flookup-function-446d94af-663b-451d-8251-369d5e3864cb%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Flookup-function-446d94af-663b-451d-8251-369d5e3864cb%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20it%20would%20be%20better%20if%20you%20share%20some%20sample%20data%20so%20that%20more%20specific%20solutions%20can%20be%20suggested.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ETauqeer%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Ho to copy an entire cell to another worksheet based on a cell value

5 Replies

Hi @ravikumarnv60 

 

There are many lookup functions (Vlookup, Index/Match, XLookup) in excel that can be used to copy or retrieve data from other worksheets or workbooks.  

 

You may also refer to the below learning material available at Microsoft Product Support:

 

https://support.microsoft.com/en-us/office/lookup-function-446d94af-663b-451d-8251-369d5e3864cb 

 

And it would be better if you share some sample data so that more specific solutions can be suggested.

 

Thanks

Tauqeer

copy all data from worksheet by pressing Ctrl+A then Ctrl+C. Now past the data to the worksheet you want using "Paste Special" as value.

@tauqeeracma  Please see the attached sample. I have this excel sheet and I want to copy the entire row into new sheet whose column G is "ADVANCE/PAYMENT". Identifier is "ADVANCE/PAYMENT".

Hi @ravikumarnv60 

 

As per my understanding you need all rows where value in column G is "ADVANCE/PAYMENT". If this is the case then "Filter" option is best to get desired rows as shown below:

tauqeeracma_0-1616503676612.png

A file with filter option is attached for your reference.

 

Thanks