Mar 21 2021 03:41 AM
Ho to copy an entire cell to another worksheet based on a cell value
Mar 23 2021 01:33 AM
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
Mar 23 2021 02:04 AM
Mar 23 2021 04:59 AM
@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".
Mar 23 2021 05:51 AM
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:
A file with filter option is attached for your reference.
Thanks
Mar 24 2021 04:32 AM