Forum Discussion
How to copy an entire cell to another worksheet based on a cell value
Ho to copy an entire cell to another worksheet based on a cell 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".
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
- Thank you