How to copy a row to another worksheet

Closed
Report
Posts
3
Registration date
Thursday April 8, 2010
Status
Member
Last seen
April 9, 2010
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
In am maintaining a file in Excel 2007 in which I would like to copy rows containing specific data in a particular column from a master worksheet to a new worksheet.
For example;
If a data is maintained in sheet no 1, and if ABC name comes in Column D row 10, then the entire row should get copied to another worksheet names as ABC, and it should get copied whenever ABC name comes in the D column.

1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768