How to copy a row to another worksheet

Closed
rohan_wagela Posts 3 Registration date Thursday April 8, 2010 Status Member Last seen April 9, 2010 - Apr 8, 2010 at 02:40 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 8, 2010 at 07:07 AM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 8, 2010 at 07:07 AM
0