Copy, to another sheet, a range of cells in a row if one cell has certain text.

[danj4fsu]

I hope I explain this so everyone understands. I have included a screenshot for some clarification. For every instance of "held" in column F, i want the corresponding cells A-E to be copied to another sheet.

https://www.dropbox.com/s/k7mbt18510m766u/inside sales 2.JPG?dl=0

TIA

 

[mumps]

You are very welcome.