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

Copper 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