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

[TABLE="width: 359"]
<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>[TR]
[TD="width: 64, bgcolor: transparent"]Sl. No[/TD]
[TD="width: 64, bgcolor: transparent"]Location[/TD]
[TD="width: 64, bgcolor: transparent"]Name [/TD]
[TD="width: 64, bgcolor: transparent"]Model [/TD]
[TD="width: 95, bgcolor: transparent"]Manufacturer [/TD]
[TD="width: 64, bgcolor: transparent"]Qty[/TD]
[TD="width: 64, bgcolor: transparent"]Remarks[/TD]
[/TR]
</tbody>[/TABLE]

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?