copy entire row based on cell vale

[cmani204]

Hi
I have an inventory excel sheet with the following heads as under and file name is Cell Drying Spare List

Sl. No

Location

Name

Model

Manufacturer

Qty

Remarks

<colgroup><col width="64" style="width: 48pt;" span="4"> <col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;"> <col width="64" style="width: 48pt;" span="2"> <tbody> </tbody>

if the value under remarks column is " send mal" then the entire should be copied to different excel file with name Report. can any one help me with this.

chandramani

 

[MARK858]

Sheet names in both workbooks? Column letter of the "Remarks" column? is the space at the start of " send mal" supposed to be there? is " send mal" the only text in the cell?